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