eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_HK_IR56 dependencies on PER_PERIODS_OF_SERVICE

Line 81: l_hire_date per_periods_of_service.date_start%TYPE;

77: l_fin_start_date DATE;
78: l_fin_end_date DATE;
79: l_processing_type pay_element_types_f.processing_type%TYPE;
80: l_particulars hr_lookups.description%TYPE;
81: l_hire_date per_periods_of_service.date_start%TYPE;
82: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
83: i NUMBER := 1;
84:
85: CURSOR csr_element_entry_dates

Line 82: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

78: l_fin_end_date DATE;
79: l_processing_type pay_element_types_f.processing_type%TYPE;
80: l_particulars hr_lookups.description%TYPE;
81: l_hire_date per_periods_of_service.date_start%TYPE;
82: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
83: i NUMBER := 1;
84:
85: CURSOR csr_element_entry_dates
86: (p_balance_name pay_balance_types.balance_name%TYPE,

Line 125: FROM per_periods_of_service pps,

121: CURSOR csr_hire_date
122: IS
123: SELECT pps.date_start,
124: pps.actual_termination_date
125: FROM per_periods_of_service pps,
126: per_people_f ppf,
127: per_assignments_f paf
128: WHERE paf.person_id = ppf.person_id
129: AND pps.person_id = paf.person_id