APPS.PAY_HK_IR56 dependencies on HR_LOOKUPS

Line 80: l_particulars hr_lookups.description%TYPE;

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

Line 114: FROM hr_lookups hrl

110:
111: CURSOR csr_particulars(p_balance_name pay_balance_types.balance_name%TYPE)
112: IS
113: SELECT hrl.description
114: FROM hr_lookups hrl
115: WHERE hrl.lookup_type = 'HK_IR56_BOX_DESC'
116: AND hrl.lookup_code = p_balance_name
117: AND to_date('3103'||p_reporting_year,'DDMMYYYY')
118: BETWEEN nvl(start_date_active,to_date('01010001','DDMMYYYY'))