APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_ALL_PEOPLE_F

Line 68: empl_start_date per_all_people_f.effective_start_date%TYPE,

64: job_id per_all_assignments_f.job_id%TYPE,
65: org_id per_all_assignments_f.organization_id%TYPE,
66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
68: empl_start_date per_all_people_f.effective_start_date%TYPE,
69: empl_end_date per_all_people_f.effective_end_date%TYPE,
70: person_id per_all_people_f.person_id%TYPE
71: );
72: --

Line 69: empl_end_date per_all_people_f.effective_end_date%TYPE,

65: org_id per_all_assignments_f.organization_id%TYPE,
66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
68: empl_start_date per_all_people_f.effective_start_date%TYPE,
69: empl_end_date per_all_people_f.effective_end_date%TYPE,
70: person_id per_all_people_f.person_id%TYPE
71: );
72: --
73: -- Following is added with more details to be captured

Line 70: person_id per_all_people_f.person_id%TYPE

66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
68: empl_start_date per_all_people_f.effective_start_date%TYPE,
69: empl_end_date per_all_people_f.effective_end_date%TYPE,
70: person_id per_all_people_f.person_id%TYPE
71: );
72: --
73: -- Following is added with more details to be captured
74: -- done by tpapired for 115.20 version of this file

Line 799: FROM per_all_assignments_f paf, per_all_people_f ppf, per_periods_of_service

795: paf.job_id,
796: paf.organization_id, paf.supervisor_id, paf.effective_start_date,
797: pps.date_start empl_start_date,
798: ppf.effective_end_date empl_end_date, ppf.person_id
799: FROM per_all_assignments_f paf, per_all_people_f ppf, per_periods_of_service
800: pps
801: WHERE paf.assignment_id = p_assignment_id
802: and trunc(sysdate) between paf.effective_start_date and
803: paf.effective_end_date

Line 815: FROM per_all_assignments_f paf, per_all_people_f ppf,

811: paf.job_id,
812: paf.organization_id, paf.supervisor_id, paf.effective_start_date,
813: pps.date_start empl_start_date,
814: ppf.effective_end_date empl_end_date, ppf.person_id
815: FROM per_all_assignments_f paf, per_all_people_f ppf,
816: per_periods_of_placement pps
817: WHERE paf.assignment_id = p_assignment_id
818: and trunc(sysdate) between paf.effective_start_date and
819: paf.effective_end_date