[Home] [Help]
775: -- cursor to check payroll periods exist up to calc_end_date
776: --
777: cursor c_last_period (p_payroll_id number) is
778: select max(tp.end_date)
779: from per_time_periods tp
780: where tp.payroll_id = p_payroll_id;
781: --
782: begin
783: hr_utility.set_location(' In: ' || l_proc,5) ;
1270: --
1271: CURSOR csr_get_payroll_end_date(c_assignment_id NUMBER
1272: ,c_calculation_date DATE) IS
1273: SELECT ptp.end_date
1274: FROM per_time_periods ptp,
1275: per_all_assignments_f paa
1276: WHERE ptp.payroll_id = paa.payroll_id
1277: AND paa.assignment_id = c_assignment_id
1278: AND c_calculation_date BETWEEN ptp.start_date AND ptp.end_date;
1438: , pay_element_entries_f ee
1439: , pay_run_results rr
1440: , pay_assignment_actions aa
1441: , pay_payroll_actions pa
1442: , per_time_periods tp
1443: where aat.absence_attendance_type_id = ab.absence_attendance_type_id
1444: and aat.absence_category in ('NZSL', 'NZVS')
1445: and ee.creator_type = 'A'
1446: and ee.creator_id = ab.absence_attendance_id
1641: cursor get_pay_period_start_date(p_assignment_id in number) is
1642: SELECT TPERIOD.start_date,
1643: TPTYPE.number_per_fiscal_year
1644: FROM pay_payroll_actions PACTION,
1645: per_time_periods TPERIOD,
1646: per_time_period_types TPTYPE
1647: where PACTION.payroll_action_id =
1648: (select max(paa.payroll_action_id)
1649: from pay_assignment_actions paa,
2039: cursor get_pay_period_start_date(p_assignment_id number) is
2040: SELECT TPERIOD.start_date,
2041: TPTYPE.number_per_fiscal_year
2042: FROM pay_payroll_actions PACTION,
2043: per_time_periods TPERIOD,
2044: per_time_period_types TPTYPE
2045: where PACTION.payroll_action_id =
2046: (select max(paa.payroll_action_id)
2047: from pay_assignment_actions paa,
2104: , pay_run_results rr -- run result for absence -- element entry
2105: , per_absence_attendances ab -- absence record
2106: , pay_assignment_actions aa -- assignment action for -- absence element entry
2107: , pay_payroll_actions pa -- payroll action for -- absence element entry
2108: , per_time_periods tp
2109: , pay_run_results rr2 -- run result for Annual -- Leave Pay element type
2110: , pay_run_result_values rrv2 -- run result value for -- Annual Leave Pay element -- pay value ,
2111: , pay_element_types_f et2 -- Annual Leave Pay element
2112: , pay_input_values_f iv2 -- Pay Value input value
2718: ,p_start_date date
2719: ,p_end_date date) is
2720: select tp.start_date
2721: , tp.end_date
2722: from per_time_periods tp
2723: where tp.payroll_id = p_payroll_id
2724: and tp.start_date <= p_end_date
2725: and tp.end_date >= p_start_date
2726: order by
3037: ,p_start_date date
3038: ,p_end_date date) is
3039: select tp.start_date
3040: , tp.end_date
3041: from per_time_periods tp
3042: where tp.payroll_id = p_payroll_id
3043: and tp.start_date <= p_end_date
3044: and tp.end_date >= p_start_date
3045: order by
3547: cursor get_pay_period_start_date(p_assignment_id number) is
3548: SELECT TPERIOD.start_date,
3549: TPTYPE.number_per_fiscal_year
3550: FROM pay_payroll_actions PACTION,
3551: per_time_periods TPERIOD,
3552: per_time_period_types TPTYPE
3553: where PACTION.payroll_action_id =
3554: (select max(paa.payroll_action_id)
3555: from pay_assignment_actions paa,
3648:
3649: cursor c_retro_start_date(p_effective_date date,
3650: p_payroll_id number) is
3651: select ptp.start_date
3652: from per_time_periods ptp
3653: ,pay_all_payrolls_f pap
3654: where pap.payroll_id = p_payroll_id
3655: and ptp.payroll_id = pap.payroll_id
3656: and (p_effective_date - pap.PAY_DATE_OFFSET) between ptp.start_date and ptp.end_date;