DBA Data[Home] [Help]

APPS.PAY_ZA_EFT_RECONCILIATION dependencies on PAY_EXTERNAL_ACCOUNTS

Line 49: PAY_EXTERNAL_ACCOUNTS PEA

45:
46: CURSOR org_payment_method_acc_no(p_effective_date date) IS
47: select SEGMENT3
48: from PAY_ORG_PAYMENT_METHODS_F OPM,
49: PAY_EXTERNAL_ACCOUNTS PEA
50: where OPM.ORG_PAYMENT_METHOD_ID = p_org_payment_method_id
51: and OPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID
52: and p_effective_date between OPM.EFFECTIVE_START_DATE and OPM.EFFECTIVE_END_DATE;
53: