APPS.PYUSDAR_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 39: pay_org_payment_methods_f to the join condition.

35: 20-APR-04 schauhan 115.39 Added date effective join condition to c_paid_actions
36: Bug 3009643
37: 20-APR-04 schauhan 115.38 Changed the query for the ref cursor c_paid_actions
38: in the procedure action_creation and added table
39: pay_org_payment_methods_f to the join condition.
40: Bug 3009643.
41: 25-FEB-04 schauhan 115.37 Changed the cursor c_paid_actions and
42: made it a reference cursor.Also used a
43: variable l_db_version to get database version

Line 276: pay_org_payment_methods_f popm

272: is null)
273: -- No run results.
274: AND NOT EXISTS (SELECT ' '
275: FROM pay_pre_payments ppp,
276: pay_org_payment_methods_f popm
277: WHERE ppp.assignment_action_id = act.assignment_action_id
278: and ppp.org_payment_method_id = popm.org_payment_method_id
279: and popm.defined_balance_id IS NOT NULL)
280: -- and is not a reversal.

Line 381: pay_org_payment_methods_f popm --Bug 3009643

377: per_all_assignments_f paf2,
378: per_periods_of_service pos,
379: pay_payroll_actions ppa_dar,
380: pay_payroll_actions ppa_mag,
381: pay_org_payment_methods_f popm --Bug 3009643
382: where ppa_dar.payroll_action_id = :pactid
383: and ppa_mag.consolidation_set_id +0 =
384: pyusdar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',
385: ppa_dar.legislative_parameters)