DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 2862: from pay_personal_payment_methods_f p

2858: into l_ppm_start_date
2859: from pay_org_payment_methods_f o
2860: where o.org_payment_method_id = ( select org_payment_method_id from(
2861: select p.org_payment_method_id
2862: from pay_personal_payment_methods_f p
2863: where p.effective_start_date >= l_old_start_date
2864: and exists
2865: (select 1
2866: from per_assignments_f a

Line 2872: update pay_personal_payment_methods_f p

2868: and a.assignment_type = p_update_type
2869: and a.person_id = p_person_id) order by p.effective_start_date)
2870: where rownum=1);
2871:
2872: update pay_personal_payment_methods_f p
2873: set p.effective_start_date = l_ppm_start_date
2874: where p.effective_start_date = l_old_start_date
2875: and p.effective_end_date >= l_new_start_date
2876: and exists