DBA Data[Home] [Help]

APPS.MYPACKAGENAME dependencies on PA_BILLING_ORIG_EVENTS_V

Line 31: FROM pa_billing_orig_events_v oe

27: -- Declare any cursors that your procedure might need here.
28:
29: CURSOR AdjLogic IS
30: SELECT event_num, event_type, organization_id
31: FROM pa_billing_orig_events_v oe
32: -- Add a WHERE clause if needed. Example:
33: -- ,pa_billing_assignments ba
34: -- WHERE ba.billing_assignment_id = oe.billing_assignment_id
35: -- AND ba.billing_extension_id = X_extn_id

Line 92: -- the pa_billing_orig_events_v view.

88: X_status => l_status,
89: X_error_message => l_error_message);
90:
91: -- You need to put proper logic to get the original event num from
92: -- the pa_billing_orig_events_v view.
93:
94: IF (X_calling_place = 'ADJ' AND X_calling_process = 'Invoice') THEN
95:
96: FOR AdjEv IN AdjLogic LOOP