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 465: l_prenote_allowed pay_all_payrolls_f.prl_information3%type;

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

Line 473: , pay_all_payrolls_f pap

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