[Home] [Help]
41: return DATE as
42:
43: cursor c_first_period_start_date(l_payroll_action_id NUMBER) is
44: select min(TPERIOD.start_date)
45: from pay_payroll_actions PACTION
46: , per_time_periods TPERIOD
47: , per_time_period_types TPTYPE
48: where PACTION.payroll_action_id = l_payroll_action_id
49: and TPERIOD.payroll_id = PACTION.payroll_id
83: c_end_date in date)
84: return date is
85: cursor csr_least_date is
86: select ptp.end_date
87: from pay_payroll_actions ppa
88: , per_time_periods ptp
89: WHERE ppa.payroll_action_id=p_payroll_action_id
90: AND ptp.payroll_id=ppa.payroll_id
91: AND ppa.DATE_EARNED between ptp.start_date and ptp.end_date;
119: -- Changed to select end_date of period (5070091)
120: cursor get_end_date(c_minimum_end_date in date) is
121: select ptp.end_date end_date
122: from
123: pay_payroll_actions ppa
124: , per_time_periods ptp
125: , per_time_period_types tptype
126: WHERE ppa.payroll_action_id=p_payroll_action_id
127: AND ptp.payroll_id=ppa.payroll_id
132: cursor get_periods(c_maximum_start_date in date,
133: c_end_date in date) is
134: select count(ptp.period_num) pay_periods
135: from
136: pay_payroll_actions ppa
137: , per_time_periods ptp
138: , per_time_period_types tptype
139: WHERE ppa.payroll_action_id=p_payroll_action_id
140: AND ptp.payroll_id=ppa.payroll_id
145: -- Cursor now counts the periods whose end date fall between the dates (5070091)
146: cursor get_cumulative_periods(c_maximum_start_date in date,c_end_date in date) is
147: select count(ptp.period_num) pay_periods
148: from
149: pay_payroll_actions ppa
150: , per_time_periods ptp
151: , per_time_period_types tptype
152: WHERE ppa.payroll_action_id=p_payroll_action_id
153: AND ptp.payroll_id=ppa.payroll_id
399: select nvl(sum(to_number(prrv.result_value)),0)
400: from pay_element_types_f pet,
401: pay_input_values_f piv,
402: pay_element_entries_f pee,
403: pay_payroll_actions ppa,
404: pay_assignment_actions paas,
405: pay_run_results prr,
406: pay_run_result_values prrv
407: where pee.element_entry_id=p_element_entry_id
415: AND paas.assignment_action_id=prr.assignment_action_id
416: AND paas.payroll_action_id=ppa.payroll_action_id
417: AND paas.assignment_id=pee.assignment_id
418: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
419: from pay_payroll_actions ppa1,
420: pay_assignment_actions paas1,
421: pay_run_results prr1,
422: pay_element_entries_f pee1
423: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)
451: select nvl(sum(to_number(prrv.result_value)),0)
452: from pay_element_types_f pet,
453: pay_input_values_f piv,
454: pay_element_entries_f pee,
455: pay_payroll_actions ppa,
456: pay_assignment_actions paas,
457: pay_run_results prr,
458: pay_run_result_values prrv
459: where pee.element_entry_id=p_element_entry_id
467: AND paas.assignment_action_id=prr.assignment_action_id
468: AND paas.payroll_action_id=ppa.payroll_action_id
469: AND paas.assignment_id=pee.assignment_id
470: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
471: from pay_payroll_actions ppa1,
472: pay_assignment_actions paas1,
473: pay_run_results prr1,
474: pay_element_entries_f pee1
475: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)
503: select nvl(sum(to_number(prrv.result_value)),0)
504: from pay_element_types_f pet,
505: pay_input_values_f piv,
506: pay_element_entries_f pee,
507: pay_payroll_actions ppa,
508: pay_assignment_actions paas,
509: pay_run_results prr,
510: pay_run_result_values prrv
511: where pee.element_entry_id=p_element_entry_id
519: AND paas.assignment_action_id=prr.assignment_action_id
520: AND paas.payroll_action_id=ppa.payroll_action_id
521: AND paas.assignment_id=pee.assignment_id
522: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
523: from pay_payroll_actions ppa1,
524: pay_assignment_actions paas1,
525: pay_run_results prr1,
526: pay_element_entries_f pee1
527: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)