[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
414: AND paas.assignment_action_id=prr.assignment_action_id
415: AND paas.payroll_action_id=ppa.payroll_action_id
416: AND paas.assignment_id=pee.assignment_id
417: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
418: from pay_payroll_actions ppa1,
419: pay_assignment_actions paas1,
420: pay_run_results prr1,
421: pay_element_entries_f pee1
422: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)
450: select nvl(sum(to_number(prrv.result_value)),0)
451: from pay_element_types_f pet,
452: pay_input_values_f piv,
453: pay_element_entries_f pee,
454: pay_payroll_actions ppa,
455: pay_assignment_actions paas,
456: pay_run_results prr,
457: pay_run_result_values prrv
458: where pee.element_entry_id=p_element_entry_id
465: AND paas.assignment_action_id=prr.assignment_action_id
466: AND paas.payroll_action_id=ppa.payroll_action_id
467: AND paas.assignment_id=pee.assignment_id
468: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
469: from pay_payroll_actions ppa1,
470: pay_assignment_actions paas1,
471: pay_run_results prr1,
472: pay_element_entries_f pee1
473: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)
501: select nvl(sum(to_number(prrv.result_value)),0)
502: from pay_element_types_f pet,
503: pay_input_values_f piv,
504: pay_element_entries_f pee,
505: pay_payroll_actions ppa,
506: pay_assignment_actions paas,
507: pay_run_results prr,
508: pay_run_result_values prrv
509: where pee.element_entry_id=p_element_entry_id
516: AND paas.assignment_action_id=prr.assignment_action_id
517: AND paas.payroll_action_id=ppa.payroll_action_id
518: AND paas.assignment_id=pee.assignment_id
519: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
520: from pay_payroll_actions ppa1,
521: pay_assignment_actions paas1,
522: pay_run_results prr1,
523: pay_element_entries_f pee1
524: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)