[Home] [Help]
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,
87: p_fin_start_date date,
88: p_fin_end_date date)
89: IS
90: SELECT min(pee.effective_start_date),
92: min(pet.processing_type)
93: FROM pay_element_types_f pet,
94: pay_element_entries_f pee,
95: pay_element_links_f pel,
96: pay_balance_types pbt,
97: pay_balance_feeds_f pbf,
98: pay_input_values_f piv
99: WHERE pee.assignment_id = p_assignment_id
100: AND pee.element_link_id = pel.element_link_id
107: (pbf.business_group_id = piv.business_group_id AND pbf.legislation_code IS NULL))
108: AND pee.effective_start_date <= p_fin_end_date
109: AND pee.effective_end_date >= p_fin_start_date;
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'
273: 'IR56_K1',11,'IR56_K2',12,'IR56_K3',13,'IR56_L',14,'IR56_M',15
274: ) sort_index,
275: pbt.balance_name,
276: pdb.defined_balance_id defined_balance_id
277: FROM pay_balance_types pbt,
278: pay_balance_dimensions pbd,
279: pay_defined_balances pdb
280: WHERE pbt.balance_name IN ('IR56_A','IR56_B','IR56_C','IR56_D','IR56_E','IR56_F','IR56_G','IR56_H',
281: 'IR56_I','IR56_J','IR56_K1','IR56_K2','IR56_K3','IR56_L','IR56_M')