DBA Data[Home] [Help]

APPS.PAY_AU_SOE_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1400: pay_org_payment_methods_f popm

1396:
1397: Cursor payroll_currency_code(c_payroll_id pay_payrolls_f.payroll_id%type) is
1398: select popm.currency_code
1399: from pay_payrolls_f ppf,
1400: pay_org_payment_methods_f popm
1401: where ppf.default_payment_method_id = popm.org_payment_method_id
1402: and ppf.payroll_id = c_payroll_id
1403: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1404: and p_effective_date between popm.effective_start_date and popm.effective_end_date;