DBA Data[Home] [Help]

APPS.HR_PERSONAL_PAY_METHOD_API dependencies on PAY_ALL_PAYROLLS_F

Line 283: , pay_all_payrolls_f pap

279: ) is
280: select nvl(pap.prl_information3, 'Y') prenote_allowed
281: from pay_personal_payment_methods_f ppm
282: , per_all_assignments_f paa
283: , pay_all_payrolls_f pap
284: where ppm.personal_payment_method_id = p_personal_payment_method_id
285: and p_effective_date between
286: ppm.effective_start_date and ppm.effective_end_date
287: and paa.assignment_id = ppm.assignment_id

Line 461: l_prenote_allowed pay_all_payrolls_f.prl_information3%type;

457: ) is
458: --
459: l_proc varchar2(72) := 'upd_prenote_date';
460: l_exa_ovn pay_external_accounts.object_version_number%type;
461: l_prenote_allowed pay_all_payrolls_f.prl_information3%type;
462: --
463: cursor csr_payroll_details(p_personal_payment_method_id in number
464: ,p_effective_date in date
465: ) is

Line 469: , pay_all_payrolls_f pap

465: ) is
466: select nvl(pap.prl_information3, 'Y') prenote_allowed
467: from pay_personal_payment_methods_f ppm
468: , per_all_assignments_f paa
469: , pay_all_payrolls_f pap
470: where ppm.personal_payment_method_id = p_personal_payment_method_id
471: and p_effective_date between
472: ppm.effective_start_date and ppm.effective_end_date
473: and paa.assignment_id = ppm.assignment_id