[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;
2852: ,p_payroll_id in number
2853: )
2854: is
2855: select start_date,end_date
2856: from per_time_periods
2857: where payroll_id = p_payroll_id
2858: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date,
2859: 'PPED',end_date,
2860: 'DTERND',regular_payment_date,
2875: ,p_payroll_id in number
2876: )
2877: is
2878: select start_date,end_date
2879: from per_time_periods
2880: where payroll_id = p_payroll_id
2881: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date,
2882: 'DTERND',regular_payment_date,
2883: 'PPED',end_date,
2890: ,p_rt_start_date in date
2891: )
2892: is
2893: select ptp.start_date,ptp.end_date
2894: from per_time_periods ptp
2895: where ptp.payroll_id = p_payroll_id
2896: and ptp.end_date<=add_months(trunc(p_rt_start_date,'YYYY'),
2897: 12)-1
2898: order by ptp.end_date desc;
2903: )
2904: is
2905: select ptp.start_date,
2906: ptp.end_date
2907: from per_time_periods ptp
2908: where ptp.payroll_id = p_payroll_id
2909: and ptp.start_date > p_rt_start_date
2910: order by ptp.end_date asc;
2911: --
2947: ,p_rt_start_date in date
2948: )
2949: is
2950: select ptp.end_date
2951: from per_time_periods ptp
2952: where ptp.payroll_id = p_payroll_id
2953: and p_rt_start_date between
2954: ptp.start_date and ptp.end_date ;
2955: --
2958: ,p_rt_start_date in date
2959: )
2960: is
2961: select nvl(ptp.regular_payment_date,ptp.end_date) end_date
2962: from per_time_periods ptp
2963: where ptp.payroll_id = p_payroll_id
2964: and p_rt_start_date between
2965: ptp.start_date and ptp.end_date ;
2966:
8015: cursor c_pps_prev_month(p_end_date in date,
8016: p_prtl_mo_eff_dt_det_cd in varchar2,
8017: p_payroll_id in number) is
8018: select start_date,end_date
8019: from per_time_periods
8020: where payroll_id = p_payroll_id
8021: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date,
8022: 'PPED',end_date,
8023: 'DTERND',regular_payment_date,
8030: cursor c_get_current_pp(p_end_date in date
8031: ,p_prtl_mo_eff_dt_det_cd in varchar2
8032: ,p_payroll_id in number) is
8033: select start_date,end_date
8034: from per_time_periods
8035: where payroll_id = p_payroll_id
8036: and p_end_date between
8037: start_date
8038: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date
8046: p_end_date in date,
8047: p_prtl_mo_eff_dt_det_cd in varchar2,
8048: p_payroll_id in number) is
8049: select start_date,end_date
8050: from per_time_periods
8051: where payroll_id = p_payroll_id
8052: and decode(p_prtl_mo_eff_dt_det_cd,'DTPD',regular_payment_date,
8053: 'PPED',end_date,
8054: 'DTERND',regular_payment_date,