[Home] [Help]
258:
259: /* Cursor to get Payslip offset date for a payroll */
260: cursor c_view_offset(cp_time_period_id in number) is
261: select payslip_view_date
262: from per_time_periods ptp
263: where time_period_id = cp_time_period_id;
264:
265: /* Cursor to get the how employee is paid */
266: cursor c_pre_payment_method
342:
343: cursor c_time_period(cp_payroll_id in number
344: ,cp_date_earned in date) is
345: select ptp.time_period_id
346: from per_time_periods ptp
347: where cp_date_earned between ptp.start_date
348: and ptp.end_Date
349: and ptp.payroll_id = cp_payroll_id;
350:
497:
498: /* Cursor to get Payslip offset date for a payroll */
499: cursor c_view_offset(cp_time_period_id in number) is
500: select payslip_view_date
501: from per_time_periods ptp
502: where time_period_id = cp_time_period_id;
503:
504: /* Cursor to get date earned for a payroll */
505: cursor c_get_date_earned(cp_assignment_action_id in number) is
511: /* Cursor to get time period for a payroll */
512: cursor c_time_period(cp_payroll_id in number
513: ,cp_date_earned in date) is
514: select ptp.time_period_id
515: from per_time_periods ptp
516: where cp_date_earned between ptp.start_date
517: and ptp.end_Date
518: and ptp.payroll_id = cp_payroll_id;
519:
602:
603: /* Cursor to get Payslip offset date for a payroll */
604: cursor c_view_offset(cp_time_period_id in number) is
605: select payslip_view_date
606: from per_time_periods ptp
607: where time_period_id = cp_time_period_id;
608:
609: /* Cursor to get date earned for a payroll */
610: cursor c_get_date_earned(cp_assignment_action_id in number) is
616: /* Cursor to get time period for a payroll */
617: cursor c_time_period(cp_payroll_id in number
618: ,cp_date_earned in date) is
619: select ptp.time_period_id
620: from per_time_periods ptp
621: where cp_date_earned between ptp.start_date
622: and ptp.end_Date
623: and ptp.payroll_id = cp_payroll_id;
624:
708:
709: /* Cursor to get Payslip offset date for a payroll */
710: cursor c_view_offset(cp_time_period_id in number) is
711: select payslip_view_date
712: from per_time_periods ptp
713: where time_period_id = cp_time_period_id;
714:
715: /* Cursor to get date earned for a payroll */
716: cursor c_get_date_earned(cp_assignment_action_id in number) is
722: /* Cursor to get time period for a payroll */
723: cursor c_time_period(cp_payroll_id in number
724: ,cp_date_earned in date) is
725: select ptp.time_period_id
726: from per_time_periods ptp
727: where cp_date_earned between ptp.start_date
728: and ptp.end_Date
729: and ptp.payroll_id = cp_payroll_id;
730:
833: /* Cursor to get Payslip offset date for a payroll */
834: --Added REGULAR_PAYMENT_DATE for bug 8550075
835: CURSOR c_view_offset(cp_time_period_id IN NUMBER) IS
836: SELECT payslip_view_date, REGULAR_PAYMENT_DATE
837: FROM per_time_periods ptp
838: WHERE time_period_id = cp_time_period_id;
839:
840: /* Cursor to get the how employee is paid */
841: cursor c_pre_payment_method
915:
916: cursor c_time_period(cp_payroll_id in number
917: ,cp_date_earned in date) is
918: select ptp.time_period_id
919: from per_time_periods ptp
920: where cp_date_earned between ptp.start_date
921: and ptp.end_Date
922: and ptp.payroll_id = cp_payroll_id;
923:
1306:
1307: cursor c_time_period(cp_payroll_id in number
1308: ,cp_date_earned in date) is
1309: select ptp.time_period_id
1310: from per_time_periods ptp
1311: where cp_date_earned between ptp.start_date
1312: and ptp.end_Date
1313: and ptp.payroll_id = cp_payroll_id;
1314:
1945: c. Here termination is not as per the SYSDATE but relative to the payroll(cycle) run date.
1946: */
1947: select max(time_period_id)
1948: into l_time_period_id
1949: from per_time_periods ptp,
1950: per_all_assignments_f paf
1951: where ptp.payroll_id= paf.payroll_id
1952: and paf.assignment_id=p_id
1953: and p_effective_date between ptp.start_date and ptp.end_date;
1952: and paf.assignment_id=p_id
1953: and p_effective_date between ptp.start_date and ptp.end_date;
1954:
1955: select nvl((select 1
1956: from per_time_periods ptp
1957: where time_period_id = l_time_period_id
1958: and( l_actual_termination_date between ptp.start_date and ptp.end_date
1959: or l_actual_termination_date < ptp.start_date)),0) into l_term_diff from dual;
1960:
2354: and nvl(actual_termination_date,p_effective_end_date) ;
2355: */
2356: /* don't show the payslip if the employee is terminated in the given pay period
2357: or prior to the given pay period */
2358: select 'N' from per_time_periods ptp
2359: where ptp.time_period_id = p_time_period_id
2360: and ( p_actual_termination_date between ptp.start_date
2361: and ptp.end_date
2362: or
2892: /* Cursor to get Payslip offset date for a payroll */
2893: --Added REGULAR_PAYMENT_DATE for bug 8550075
2894: CURSOR c_view_offset(cp_time_period_id IN NUMBER) IS
2895: SELECT payslip_view_date, REGULAR_PAYMENT_DATE
2896: FROM per_time_periods ptp
2897: WHERE time_period_id = cp_time_period_id;
2898:
2899: /* Cursor to get the how employee is paid */
2900: CURSOR c_pre_payment_method
2974:
2975: CURSOR c_time_period(cp_payroll_id IN NUMBER
2976: , cp_date_earned IN DATE) IS
2977: SELECT ptp.time_period_id
2978: FROM per_time_periods ptp
2979: WHERE cp_date_earned BETWEEN ptp.start_date
2980: AND ptp.end_Date
2981: AND ptp.payroll_id = cp_payroll_id;
2982: