APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_TIME_PERIODS

Line 198: from per_time_periods ptp

194:
195: /* Cursor to get Payslip offset date for a payroll */
196: cursor c_view_offset(cp_time_period_id in number) is
197: select payslip_view_date
198: from per_time_periods ptp
199: where time_period_id = cp_time_period_id;
200:
201: /* Cursor to get the how employee is paid */
202: cursor c_pre_payment_method

Line 282: from per_time_periods ptp

278:
279: cursor c_time_period(cp_payroll_id in number
280: ,cp_date_earned in date) is
281: select ptp.time_period_id
282: from per_time_periods ptp
283: where cp_date_earned between ptp.start_date
284: and ptp.end_Date
285: and ptp.payroll_id = cp_payroll_id;
286:

Line 454: from per_time_periods ptp

450:
451: /* Cursor to get Payslip offset date for a payroll */
452: cursor c_view_offset(cp_time_period_id in number) is
453: select payslip_view_date
454: from per_time_periods ptp
455: where time_period_id = cp_time_period_id;
456:
457: /* Cursor to get the how employee is paid */
458: cursor c_pre_payment_method

Line 543: from per_time_periods ptp

539:
540: cursor c_time_period(cp_payroll_id in number
541: ,cp_date_earned in date) is
542: select ptp.time_period_id
543: from per_time_periods ptp
544: where cp_date_earned between ptp.start_date
545: and ptp.end_Date
546: and ptp.payroll_id = cp_payroll_id;
547: --bug 6840881 starts here

Line 722: from per_time_periods ptp

718:
719: cursor c_time_period(cp_payroll_id in number
720: ,cp_date_earned in date) is
721: select ptp.time_period_id
722: from per_time_periods ptp
723: where cp_date_earned between ptp.start_date
724: and ptp.end_Date
725: and ptp.payroll_id = cp_payroll_id;
726:

Line 1712: select 'N' from per_time_periods ptp

1708: and nvl(actual_termination_date,p_effective_end_date) ;
1709: */
1710: /* don't show the payslip if the employee is terminated in the given pay period
1711: or prior to the given pay period */
1712: select 'N' from per_time_periods ptp
1713: where ptp.time_period_id = p_time_period_id
1714: and ( p_actual_termination_date between ptp.start_date
1715: and ptp.end_date
1716: or