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