[Home] [Help]
176: select d.assignment_action_id,
177: g.end_date
178: from pay_assignment_actions d,
179: pay_payroll_actions e,
180: per_time_periods g
181: where d.assignment_id = c_assignment_id
182: and g.payroll_id = c_payroll_id
183: and g.payroll_id = e.payroll_id
184: and d.payroll_action_id = e.payroll_action_id
293: select 'Y'
294: from pay_run_results result,
295: pay_assignment_actions asgt_action,
296: pay_payroll_actions pay_action,
297: per_time_periods period
298: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)
299: and result.status <> 'U'
300: and result.source_type = 'E'
301: and result.assignment_action_id = asgt_action.assignment_action_id
999: pay_payroll_actions pa,
1000: pay_quickpay_inclusions qi,
1001: pay_element_links_f el,
1002: pay_element_entries_f ee,
1003: per_time_periods tp
1004: where aa.assignment_id = p_assignment_id
1005: and pa.payroll_action_id = aa.payroll_action_id
1006: and pa.action_type = 'Q'
1007: and pa.time_period_id = tp.time_period_id
1019: cursor c_periods(v_payroll_id in number,
1020: v_start_date in date,
1021: v_end_date in date) is
1022: select end_date
1023: from per_time_periods ptp
1024: where ptp.payroll_id = v_payroll_id
1025: and ptp.end_date between
1026: v_start_date and v_end_date;
1027: l_quick_pay_inclusion c_quick_pay_inclusion%rowtype;
1089: cursor c_periods(v_payroll_id in number,
1090: v_start_date in date,
1091: v_end_date in date) is
1092: select end_date
1093: from per_time_periods ptp
1094: where ptp.payroll_id = v_payroll_id
1095: and ptp.end_date between
1096: v_start_date and v_end_date;
1097: l_end_date date;
2683: AND ann_rt_val = p_annual_amt;
2684:
2685: cursor c_pp_start_dt is
2686: SELECT ptp.start_date
2687: FROM per_time_periods ptp
2688: WHERE ptp.payroll_id = p_payroll_id
2689: AND ptp.start_date <= p_last_pp_strt_dt
2690: ORDER BY ptp.start_date DESC;
2691:
2690: ORDER BY ptp.start_date DESC;
2691:
2692: cursor c_pp_end_dt is
2693: SELECT ptp.end_date
2694: FROM per_time_periods ptp
2695: WHERE ptp.payroll_id = p_payroll_id
2696: AND ptp.end_date <= p_last_pp_end_dt
2697: ORDER BY ptp.start_date DESC;
2698:
2983: ,p_payroll_id in number
2984: )
2985: is
2986: select start_date,end_date
2987: from per_time_periods
2988: where payroll_id = p_payroll_id
2989: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date,
2990: 'PPED',end_date,
2991: 'DTERND',regular_payment_date,
3006: ,p_payroll_id in number
3007: )
3008: is
3009: select start_date,end_date
3010: from per_time_periods
3011: where payroll_id = p_payroll_id
3012: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date,
3013: 'DTERND',regular_payment_date,
3014: 'PPED',end_date,
3021: ,p_rt_start_date in date
3022: )
3023: is
3024: select ptp.start_date,ptp.end_date
3025: from per_time_periods ptp
3026: where ptp.payroll_id = p_payroll_id
3027: and ptp.end_date<=add_months(trunc(p_rt_start_date,'YYYY'),
3028: 12)-1
3029: order by ptp.end_date desc;
3034: )
3035: is
3036: select ptp.start_date,
3037: ptp.end_date
3038: from per_time_periods ptp
3039: where ptp.payroll_id = p_payroll_id
3040: and ptp.start_date > p_rt_start_date
3041: order by ptp.end_date asc;
3042: --
3078: ,p_rt_start_date in date
3079: )
3080: is
3081: select ptp.end_date
3082: from per_time_periods ptp
3083: where ptp.payroll_id = p_payroll_id
3084: and p_rt_start_date between
3085: ptp.start_date and ptp.end_date ;
3086: --
3090: )
3091: is
3092: select nvl(ptp.regular_payment_date,ptp.end_date) end_date
3093: ,ptp.end_date ptp_end_date -- Bug 8985608
3094: from per_time_periods ptp
3095: where ptp.payroll_id = p_payroll_id
3096: and p_rt_start_date between
3097: ptp.start_date and ptp.end_date ;
3098:
3148: ------------------Bug 8872583
3149: cursor c_chk_pay_periods(p_payroll_id number,p_date date)
3150: is
3151: SELECT *
3152: FROM per_time_periods ptp
3153: WHERE payroll_id = p_payroll_id
3154: AND p_date BETWEEN ptp.start_date AND ptp.end_date ;
3155:
3156: l_chk_pay_periods c_chk_pay_periods%rowtype;
3411: --
3412: CURSOR c_pay_period_strt_dt(p_effective_start_date date
3413: ) IS
3414: SELECT ptp.start_date
3415: FROM per_time_periods ptp
3416: ,per_all_assignments_f asg
3417: WHERE ptp.regular_payment_date >= p_effective_start_date
3418: and ptp.payroll_id = asg.payroll_id
3419: AND ptp.start_date <= p_effective_start_date
8576: cursor c_pps_prev_month(p_end_date in date,
8577: p_prtl_mo_eff_dt_det_cd in varchar2,
8578: p_payroll_id in number) is
8579: select start_date,end_date
8580: from per_time_periods
8581: where payroll_id = p_payroll_id
8582: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date,
8583: 'PPED',end_date,
8584: 'DTERND',regular_payment_date,
8591: cursor c_get_current_pp(p_end_date in date
8592: ,p_prtl_mo_eff_dt_det_cd in varchar2
8593: ,p_payroll_id in number) is
8594: select start_date,end_date
8595: from per_time_periods
8596: where payroll_id = p_payroll_id
8597: and p_end_date between
8598: start_date
8599: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date
8607: p_end_date in date,
8608: p_prtl_mo_eff_dt_det_cd in varchar2,
8609: p_payroll_id in number) is
8610: select start_date,end_date
8611: from per_time_periods
8612: where payroll_id = p_payroll_id
8613: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date,
8614: 'PPED',end_date,
8615: 'DTERND',regular_payment_date,
8872: l_chk_payroll_chg c_chk_payroll_chg%rowtype;
8873:
8874: cursor c_days_in_pp(p_payroll_id number,p_rt_end_date date) is
8875: SELECT ((end_date - START_DATE) + 1)
8876: FROM per_time_periods
8877: WHERE payroll_id = p_payroll_id
8878: AND p_rt_end_date BETWEEN start_date AND end_date;
8879:
8880: l_old_pp_days number;