DBA Data[Home] [Help]

APPS.OE_CREDIT_WF dependencies on WF_ACTIVITY_TRANSITIONS

Line 951: FROM wf_activity_transitions atr

947: AND wpa.activity_name = 'PICK_RELEASE';
948: -- Checks if the next activity is pick release
949: CURSOR next_pick_rel IS
950: SELECT count(*)
951: FROM wf_activity_transitions atr
952: WHERE atr.from_process_activity = l_fromact_id
953: AND result_code = 'APPROVED'
954: AND to_process_activity IN
955: (SELECT pa.instance_id