APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PER_TIME_PERIODS

Line 1308: FROM per_time_periods

1304:
1305: CURSOR c_period_details (cp_time_period_id NUMBER)
1306: IS
1307: SELECT payroll_id, period_type, start_date, cut_off_date
1308: FROM per_time_periods
1309: WHERE time_period_id = cp_time_period_id;
1310:
1311: cursor c_step (cp_sp_ceil_step_id in number,
1312: cp_effective_date in date) is

Line 2210: per_time_periods ptp

2206: SELECT DISTINCT peef.element_entry_id
2207: FROM pay_element_entries_f peef,
2208: pay_assignment_actions paa,
2209: pay_payroll_actions ppa,
2210: per_time_periods ptp
2211: WHERE paa.assignment_action_id = cp_run_action_id
2212: AND ppa.payroll_action_id = paa.payroll_action_id
2213: AND ptp.payroll_id = ppa.payroll_id
2214: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date

Line 3301: per_time_periods ptp

3297: SELECT ptp.time_period_id,
3298: NVL(ppa.date_earned,ppa.effective_date)
3299: FROM pay_assignment_actions paa,
3300: pay_payroll_actions ppa,
3301: per_time_periods ptp
3302: WHERE paa.assignment_action_id = cp_run_assignment_action
3303: AND ppa.payroll_action_id = paa.payroll_action_id
3304: AND ptp.payroll_id = ppa.payroll_id
3305: AND NVL(ppa.date_earned,ppa.effective_date)

Line 3314: ln_time_period_id per_time_periods.time_period_id%TYPE;

3310: ln_ytd_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3311:
3312: lv_res_jurisdiction_code VARCHAR2(30);
3313:
3314: ln_time_period_id per_time_periods.time_period_id%TYPE;
3315: ld_run_date_earned DATE;
3316:
3317: BEGIN
3318: