Hi guys,
Can any one help me....
issue is in the trigger below one

IF (:new.A_PARTY_TYPE IN ('ORB','OPB','OBL') OR ld.A_PARTY_TYPE IN ('ORB','OPB','OBL')) THEN

instead of passing the hardcoded values i want to pass the select statement, like SELECE VALUE FROM PARTY

can any one help me to do that.

Thanks
kiran