DBA Data[Home] [Help]

APPS.HR_PERSONAL_PAY_METHOD_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 282: , per_all_assignments_f paa

278: ,p_effective_date in date
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

Line 472: , per_all_assignments_f paa

468: ,p_effective_date in date
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