APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 316: pay_org_payment_methods_f popm,

312: (select 1
313: from pay_action_interlocks pai_mag,
314: pay_assignment_actions paa_mag,
315: pay_payroll_actions ppa_mag,
316: pay_org_payment_methods_f popm,
317: pay_pre_payments ppp,
318: pay_payment_types ppt
319: where pai_mag.locked_action_id = cp_prepayment_action_id
320: and pai_mag.locking_Action_id = paa_mag.assignment_action_id

Line 345: pay_org_payment_methods_f popm

341: from dual
342: where not exists
343: (select 1
344: from pay_pre_payments ppp ,
345: pay_org_payment_methods_f popm
346: where ppp.assignment_action_id = cp_prepayment_action_id
347: and popm.ORG_PAYMENT_METHOD_ID = ppp.org_payment_method_id
348: and popm.defined_balance_id is not NULL );
349:

Line 737: pay_org_payment_methods_f popm,

733: ppa_mag.action_type
734: from pay_assignment_actions act,
735: pay_payroll_actions ppa_dar,
736: pay_payroll_actions ppa_mag,
737: pay_org_payment_methods_f popm,
738: pay_all_payrolls_f ppf,
739: per_all_assignments_f paf2,
740: hr_assignment_sets has,
741: hr_assignment_set_amendments hasa

Line 776: pay_org_payment_methods_f popm

772: and act.assignment_id between stperson and endperson
773: -- No run results.
774: and NOT EXISTS (SELECT ' '
775: FROM pay_pre_payments ppp,
776: pay_org_payment_methods_f popm
777: WHERE ppp.assignment_action_id = decode(act.source_action_id,NULL
778: ,act.assignment_action_id,
779: act.source_action_id) --Bug 3928576.Check only for master actions.
780: and ppp.org_payment_method_id = popm.org_payment_method_id

Line 902: pay_org_payment_methods_f popm, --Bug 3009643

898: from pay_assignment_actions act,
899: pay_payroll_actions ppa_dar,
900: pay_payroll_actions ppa_mag,
901: per_all_assignments_f paf2,
902: pay_org_payment_methods_f popm, --Bug 3009643
903: pay_payrolls_f pay --Bug 3343621
904: where ppa_dar.payroll_action_id = :pactid
905: and ppa_mag.consolidation_set_id +0 = '|| nvl(ln_consolidation_set_id,0) ||'
906: and ppa_mag.effective_date between

Line 934: pay_org_payment_methods_f popm

930:
931: -- No run results.
932: and NOT EXISTS (SELECT '' ''
933: FROM pay_pre_payments ppp,
934: pay_org_payment_methods_f popm
935: WHERE ppp.assignment_action_id = decode(act.source_action_id,NULL
936: ,act.assignment_action_id,
937: act.source_action_id) --Bug 3928576.Check only for master actions.
938: and ppp.org_payment_method_id = popm.org_payment_method_id