APPS.PAY_GB_EOY_ARCHIVE dependencies on PER_TIME_PERIODS

Line 1387: FROM per_time_periods ptp

1383: min(start_date) start_year,
1384: max(end_date) end_year,
1385: max(period_type) period_type,
1386: max(period_num) max_period_number
1387: FROM per_time_periods ptp
1388: WHERE ptp.payroll_id = p_payroll_id
1389: AND ptp.regular_payment_date BETWEEN p_start_year
1390: AND p_end_year;
1391: --

Line 3398: FROM per_time_periods ptp

3394: <= least(p_asg_end,g_end_year);
3395: --
3396: CURSOR get_week_53_start(p_payroll_id NUMBER) IS
3397: SELECT start_date
3398: FROM per_time_periods ptp
3399: WHERE payroll_id = p_payroll_id
3400: AND regular_payment_date BETWEEN g_start_year AND g_end_year
3401: AND period_num = l_payroll_max_period_number;
3402: --

Line 3420: per_time_periods ptp

3416: paa.assignment_action_id),16)),
3417: max(pact.effective_date) effective_date
3418: FROM pay_assignment_actions paa,
3419: pay_payroll_actions pact,
3420: per_time_periods ptp
3421: WHERE paa.assignment_id = p_asgid
3422: AND paa.payroll_action_id = pact.payroll_action_id
3423: AND pact.time_period_id = ptp.time_period_id
3424: AND pact.action_type IN ('Q','R','B','I','V')

Line 3594: ,per_time_periods bptp

3590: ,pay_element_links_f el_ni
3591: ,pay_payroll_actions pact
3592: ,pay_assignment_actions assact
3593: ,pay_payroll_actions bact
3594: ,per_time_periods bptp
3595: ,per_time_periods pptp
3596: ,pay_assignment_actions bal_assact
3597: WHERE bal_assact.assignment_action_id = cp_l_asg_id
3598: AND bal_assact.payroll_action_id = bact.payroll_action_id

Line 3595: ,per_time_periods pptp

3591: ,pay_payroll_actions pact
3592: ,pay_assignment_actions assact
3593: ,pay_payroll_actions bact
3594: ,per_time_periods bptp
3595: ,per_time_periods pptp
3596: ,pay_assignment_actions bal_assact
3597: WHERE bal_assact.assignment_action_id = cp_l_asg_id
3598: AND bal_assact.payroll_action_id = bact.payroll_action_id
3599: AND feed.balance_type_id = bal.balance_type_id