APPS.HRHIRAPL dependencies on PER_APPLICATIONS

Line 744: update per_applications pap

740: -- the fact the table does not have stored a retain value .
741: --
742: hr_utility.set_location('hrhiapl.make_secondary',2);
743: --
744: update per_applications pap
745: set date_end = p_start_date -1,
746: successful_flag = 'Y'
747: where pap.person_id = p_person_id -- added for bug 5469726
748: and exists (select '1'

Line 1202: from per_applications

1198:
1199:
1200: cursor appl_rec_det(l_appl_id number) is
1201: select projected_hire_date
1202: from per_applications
1203: where application_id =l_appl_id;
1204:
1205:
1206:

Line 3222: from per_applications

3218: l_date_probation_end date;
3219:
3220: cursor appl_rec_det1(l_appl_id number) is
3221: select projected_hire_date
3222: from per_applications
3223: where application_id =l_appl_id;
3224:
3225: --7120387
3226: --

Line 4758: from per_applications

4754: and effective_end_date;
4755:
4756: cursor appl_rec_det(l_appl_id number) is
4757: select projected_hire_date
4758: from per_applications
4759: where application_id =l_appl_id;
4760:
4761: l_date_probation_end date;
4762: l_proj_hire_date date;