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 468: , per_all_assignments_f paa

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