DBA Data[Home] [Help]

APPS.OE_CREDIT_WF dependencies on WF_ACTIVITY_TRANSITIONS

Line 923: FROM wf_activity_transitions atr

919: AND wpa.activity_name = 'PICK_RELEASE';
920: -- Checks if the next activity is pick release
921: CURSOR next_pick_rel IS
922: SELECT count(*)
923: FROM wf_activity_transitions atr
924: WHERE atr.from_process_activity = l_fromact_id
925: AND result_code = 'APPROVED'
926: AND to_process_activity IN
927: (SELECT pa.instance_id