[Home] [Help]
121: FROM pay_assignment_actions paa
122: , pay_payroll_actions ppa
123: , per_assignments_f paf
124: , pay_payrolls_f ppf
125: , per_time_periods ptp
126: WHERE paf.assignment_id = c_assignment_id
127: AND paf.assignment_id = paa.assignment_id
128: AND ppf.payroll_id = ppa.payroll_id
129: AND ppf.payroll_id = paf.payroll_id
633: FROM pay_assignment_actions paa
634: , pay_payroll_actions ppa
635: , per_assignments_f paf
636: , pay_payrolls_f ppf
637: , per_time_periods ptp
638: WHERE paf.assignment_id = c_assignment_id
639: AND paf.assignment_id = paa.assignment_id
640: AND ppf.payroll_id = ppa.payroll_id
641: AND ppf.payroll_id = paf.payroll_id
663: FROM pay_assignment_actions paa
664: , pay_payroll_actions ppa
665: , per_assignments_f paf
666: , pay_payrolls_f ppf
667: , per_time_periods ptp
668: WHERE paf.assignment_id = c_assignment_id
669: AND paf.assignment_id = paa.assignment_id
670: AND ppf.payroll_id = ppa.payroll_id
671: AND ppf.payroll_id = paf.payroll_id
698: -- Bug# 2264070 Added the join on payroll_action_id
699: cursor get_pay_period_start_date(p_assignment_id in number) is
700: SELECT TPERIOD.start_date FROM
701: pay_payroll_actions PACTION
702: , per_time_periods TPERIOD
703: , per_time_period_types TPTYPE
704: where PACTION.payroll_action_id = (select max(paa.payroll_action_id)
705: from pay_assignment_actions paa,pay_payroll_actions ppa
706: where paa.assignment_id=p_assignment_id
712:
713: cursor get_next_pay_period_start_date(p_assignment_id in number,
714: p_effective_date in date) is
715: select MIN(ptp.start_date)
716: from per_time_periods ptp,per_all_assignments_f paa
717: where ptp.start_date > p_effective_date
718: and paa.assignment_id = p_assignment_id
719: and paa.payroll_id = ptp.payroll_id;
720:
722: financial years last pay period */
723: cursor get_max_fin_year_end(c_assignment_id in number,
724: c_effective_date in date) is
725: select MAX(ptp.end_date)
726: from per_time_periods ptp,
727: per_all_assignments_f paa
728: where ptp.start_date >= add_months(c_effective_date+1,-12)
729: and ptp.end_date <= c_effective_date
730: and paa.assignment_id = c_assignment_id
1396: -- has the processing time period expired
1397: --
1398: cursor expired_time_period (c_assignment_action_id number) is
1399: select ptp.end_date
1400: from per_time_periods ptp
1401: , pay_payroll_actions ppa
1402: , pay_assignment_actions paa
1403: where paa.assignment_action_id = c_assignment_action_id
1404: and paa.payroll_action_id = ppa.payroll_action_id
1687: l_end_date date;
1688: --
1689: cursor expired_time_period ( c_assignment_action_id in number ) is
1690: select ptp.end_date
1691: from per_time_periods ptp
1692: , pay_payroll_actions ppa
1693: , pay_assignment_actions paa
1694: where paa.assignment_action_id = c_assignment_action_id
1695: and paa.payroll_action_id = ppa.payroll_action_id
1837: l_end_date date;
1838: --
1839: cursor expired_time_period( c_assignment_action_id in number ) is
1840: select ptp.end_date
1841: from per_time_periods ptp
1842: , pay_payroll_actions ppa
1843: , pay_assignment_actions paa
1844: where paa.assignment_action_id = c_assignment_action_id
1845: and paa.payroll_action_id = ppa.payroll_action_id