APPS.PAY_HK_IR56 dependencies on PER_PERIODS_OF_SERVICE

Line 88: l_hire_date per_periods_of_service.date_start%TYPE;

84: l_fin_start_date DATE;
85: l_fin_end_date DATE;
86: l_processing_type pay_element_types_f.processing_type%TYPE;
87: l_particulars hr_lookups.description%TYPE;
88: l_hire_date per_periods_of_service.date_start%TYPE;
89: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
90: i NUMBER := 1;
91:
92: l_exists NUMBER := 0;

Line 89: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

85: l_fin_end_date DATE;
86: l_processing_type pay_element_types_f.processing_type%TYPE;
87: l_particulars hr_lookups.description%TYPE;
88: l_hire_date per_periods_of_service.date_start%TYPE;
89: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
90: i NUMBER := 1;
91:
92: l_exists NUMBER := 0;
93:

Line 134: FROM per_periods_of_service pps,

130: CURSOR csr_hire_date
131: IS
132: SELECT pps.date_start,
133: pps.actual_termination_date
134: FROM per_periods_of_service pps,
135: per_people_f ppf,
136: per_assignments_f paf
137: WHERE paf.person_id = ppf.person_id
138: AND pps.person_id = paf.person_id