DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 651: FROM pay_org_payment_methods_f popm

647: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NAME', pea.territory_code),
648: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
649: pea.segment4,
650: pea.segment2
651: FROM pay_org_payment_methods_f popm
652: , pay_external_accounts pea
653: WHERE org_payment_method_id = p_org_payment_method_id
654: AND popm.external_account_id = pea.external_account_id
655: AND p_effective_date between popm.EFFECTIVE_START_DATE

Line 690: , pay_org_payment_methods_f popm

686: , pay_assignment_actions paa
687: , pay_assignment_actions paa_chq
688: , pay_payroll_actions ppa
689: , pay_payroll_actions ppa_chq
690: , pay_org_payment_methods_f popm
691: WHERE paa_chq.assignment_action_id = cp_chk_action_id
692: and paa_chq.assignment_action_id = pai.locking_action_id
693: and pai.locked_action_id = paa.assignment_action_id
694: and paa.payroll_action_id = ppa.payroll_action_id