APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 311: pay_org_payment_methods_f popm,

307: (select 1
308: from pay_action_interlocks pai_mag,
309: pay_assignment_actions paa_mag,
310: pay_payroll_actions ppa_mag,
311: pay_org_payment_methods_f popm,
312: pay_pre_payments ppp,
313: pay_payment_types ppt
314: where pai_mag.locked_action_id = cp_prepayment_action_id
315: and pai_mag.locking_Action_id = paa_mag.assignment_action_id

Line 340: pay_org_payment_methods_f popm

336: from dual
337: where not exists
338: (select 1
339: from pay_pre_payments ppp ,
340: pay_org_payment_methods_f popm
341: where ppp.assignment_action_id = cp_prepayment_action_id
342: and popm.ORG_PAYMENT_METHOD_ID = ppp.org_payment_method_id
343: and popm.defined_balance_id is not NULL );
344:

Line 727: pay_org_payment_methods_f popm,

723: ppa_mag.action_type
724: from pay_assignment_actions act,
725: pay_payroll_actions ppa_dar,
726: pay_payroll_actions ppa_mag,
727: pay_org_payment_methods_f popm,
728: pay_all_payrolls_f ppf,
729: per_all_assignments_f paf2,
730: hr_assignment_sets has,
731: hr_assignment_set_amendments hasa

Line 766: pay_org_payment_methods_f popm

762: and act.assignment_id between stperson and endperson
763: -- No run results.
764: and NOT EXISTS (SELECT ' '
765: FROM pay_pre_payments ppp,
766: pay_org_payment_methods_f popm
767: WHERE ppp.assignment_action_id = decode(act.source_action_id,NULL
768: ,act.assignment_action_id,
769: act.source_action_id) --Bug 3928576.Check only for master actions.
770: and ppp.org_payment_method_id = popm.org_payment_method_id

Line 892: pay_org_payment_methods_f popm, --Bug 3009643

888: from pay_assignment_actions act,
889: pay_payroll_actions ppa_dar,
890: pay_payroll_actions ppa_mag,
891: per_all_assignments_f paf2,
892: pay_org_payment_methods_f popm, --Bug 3009643
893: pay_payrolls_f pay --Bug 3343621
894: where ppa_dar.payroll_action_id = :pactid
895: and ppa_mag.consolidation_set_id +0 = '|| nvl(ln_consolidation_set_id,0) ||'
896: and ppa_mag.effective_date between

Line 924: pay_org_payment_methods_f popm

920:
921: -- No run results.
922: and NOT EXISTS (SELECT '' ''
923: FROM pay_pre_payments ppp,
924: pay_org_payment_methods_f popm
925: WHERE ppp.assignment_action_id = decode(act.source_action_id,NULL
926: ,act.assignment_action_id,
927: act.source_action_id) --Bug 3928576.Check only for master actions.
928: and ppp.org_payment_method_id = popm.org_payment_method_id