[Home] [Help]
172: and ppa.time_period_id = ptp.time_period_id
173: and ptp.end_date between to_date('1-10-2007','DD-MM-YYYY')
174: and to_date('31-10-2007','DD-MM-YYYY')
175: and exists (select 1
176: from pay_run_results prr
177: where element_type_id =l_ee_contr_ele_type_id
178: and prr.assignment_action_id = paa.assignment_action_id
179: ) ;
180: exception
209: and ppa.time_period_id = ptp.time_period_id
210: and ptp.end_date between to_date('1-11-2007','DD-MM-YYYY')
211: and to_date('30-11-2007','DD-MM-YYYY')
212: and exists (select 1
213: from pay_run_results prr
214: where element_type_id =l_ee_contr_ele_type_id
215: and prr.assignment_action_id = paa.assignment_action_id
216: ) ;
217: exception
246: and ppa.time_period_id = ptp.time_period_id
247: and ptp.end_date between to_date('1-12-2007','DD-MM-YYYY')
248: and to_date('31-12-2007','DD-MM-YYYY')
249: and exists (select 1
250: from pay_run_results prr
251: where element_type_id =l_ee_contr_ele_type_id
252: and prr.assignment_action_id = paa.assignment_action_id
253: ) ;
254: exception
282: and ppa.time_period_id = ptp.time_period_id
283: and ptp.end_date between to_date('1-01-2008','DD-MM-YYYY')
284: and to_date('31-01-2008','DD-MM-YYYY')
285: and exists (select 1
286: from pay_run_results prr
287: where element_type_id =l_ee_contr_ele_type_id
288: and prr.assignment_action_id = paa.assignment_action_id
289: ) ;
290: exception
319: ) is
320: cursor c_get_rrv_dtls (p_ele_type_id number, p_ip_value_id number) is
321: select prrv.result_value
322: , prr.element_entry_id
323: from pay_run_results prr
324: , pay_run_result_values prrv
325: where prr.assignment_action_id = p_asg_act_id
326: and prr.element_type_id = p_ele_type_id
327: and prrv.run_result_id = prr.run_result_id
875:
876: cursor c_get_ee_id (p_ele_type_id number
877: ,p_asact_id number) is
878: select prr.element_entry_id
879: from pay_run_results prr
880: where prr.assignment_action_id = p_asact_id
881: and prr.element_type_id = p_ele_type_id ;
882:
883: l_asg_id number;