DBA Data[Home] [Help]

APPS.HR_DATE_CHK dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 123: from pay_personal_payment_methods_f pa

119: where pa.person_id = p_person_id
120: for update of person_id;
121: cursor pay is
122: select 'pay'
123: from pay_personal_payment_methods_f pa
124: where pa.assignment_id IN (select a.assignment_id
125: from per_assignments_f a
126: where a.assignment_type = 'E'
127: and a.person_id = p_person_id)

Line 782: update pay_personal_payment_methods_f p

778: and a.person_id = p_person_id;
779: --
780: --
781: hr_utility.set_location('hr_date_chk.update_hire_records',2);
782: update pay_personal_payment_methods_f p
783: set p.effective_start_date = p_start_date
784: where p.effective_start_date = p_s_start_date
785: and p.effective_end_date >= p_start_date
786: and exists (select 1