APPS.PAY_HK_IR56 dependencies on HR_LOOKUPS

Line 87: l_particulars hr_lookups.description%TYPE;

83: l_end_date DATE;
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:

Line 123: FROM hr_lookups hrl

119:
120: CURSOR csr_particulars(p_balance_name pay_balance_types.balance_name%TYPE)
121: IS
122: SELECT hrl.description
123: FROM hr_lookups hrl
124: WHERE hrl.lookup_type = 'HK_IR56_BOX_DESC'
125: AND hrl.lookup_code = p_balance_name
126: AND to_date('3103'||p_reporting_year,'DDMMYYYY')
127: BETWEEN nvl(start_date_active,to_date('01010001','DDMMYYYY'))