[Home] [Help]
91:
92: l_exists NUMBER := 0;
93:
94: CURSOR csr_element_entry_dates
95: (p_balance_name pay_balance_types.balance_name%TYPE,
96: p_fin_start_date date,
97: p_fin_end_date date)
98: IS
99: SELECT min(pee.effective_start_date),
101: min(pet.processing_type)
102: FROM pay_element_types_f pet,
103: pay_element_entries_f pee,
104: pay_element_links_f pel,
105: pay_balance_types pbt,
106: pay_balance_feeds_f pbf,
107: pay_input_values_f piv
108: WHERE pee.assignment_id = p_assignment_id
109: AND pee.element_link_id = pel.element_link_id
116: (pbf.business_group_id = piv.business_group_id AND pbf.legislation_code IS NULL))
117: AND pee.effective_start_date <= p_fin_end_date
118: AND pee.effective_end_date >= p_fin_start_date;
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'
141:
142: /* Bug 8406450 - Check if any Balance Ajdustments have been done for balance */
143:
144: CURSOR csr_balance_adj_exist
145: (p_balance_name pay_balance_types.balance_name%TYPE,
146: p_fin_start_date date,
147: p_fin_end_date date)
148: IS
149: SELECT COUNT(pivf.input_value_id)
149: SELECT COUNT(pivf.input_value_id)
150: FROM pay_element_entries_f pee,
151: pay_element_types_f pet,
152: pay_input_values_f pivf,
153: pay_balance_types pbt,
154: pay_balance_feeds_f pbf
155: WHERE pee.assignment_id = p_assignment_id
156: AND pee.entry_type = 'B'
157: AND pee.element_type_id = pet.element_type_id
323: 'IR56_K1',11,'IR56_K2',12,'IR56_K3',13,'IR56_L',14,'IR56_M',15
324: ) sort_index,
325: pbt.balance_name,
326: pdb.defined_balance_id defined_balance_id
327: FROM pay_balance_types pbt,
328: pay_balance_dimensions pbd,
329: pay_defined_balances pdb
330: WHERE pbt.balance_name IN ('IR56_A','IR56_B','IR56_C','IR56_D','IR56_E','IR56_F','IR56_G','IR56_H',
331: 'IR56_I','IR56_J','IR56_K1','IR56_K2','IR56_K3','IR56_L','IR56_M')