DBA Data[Home] [Help]

APPS.PAY_WF_PKG dependencies on PAY_PAYROLLS_F

Line 2046: from pay_payrolls_f prl

2042: -- get the payroll contact
2043:
2044: CURSOR c_payroll_contact IS
2045: select prl.prl_information1
2046: from pay_payrolls_f prl
2047: where prl.payroll_id = ln_payroll_id
2048: and prl.prl_information_category = 'US'
2049: and fnd_date.canonical_to_date(l_effective_date) between
2050: prl.effective_start_date and prl.effective_end_date;