APPS.PAY_GB_EOY_ARCHIVE dependencies on PER_TIME_PERIODS

Line 1361: FROM per_time_periods ptp

1357: min(start_date) start_year,
1358: max(end_date) end_year,
1359: max(period_type) period_type,
1360: max(period_num) max_period_number
1361: FROM per_time_periods ptp
1362: WHERE ptp.payroll_id = p_payroll_id
1363: AND ptp.regular_payment_date BETWEEN p_start_year
1364: AND p_end_year;
1365: --

Line 3271: FROM per_time_periods ptp

3267: <= least(p_asg_end,g_end_year);
3268: --
3269: CURSOR get_week_53_start(p_payroll_id NUMBER) IS
3270: SELECT start_date
3271: FROM per_time_periods ptp
3272: WHERE payroll_id = p_payroll_id
3273: AND regular_payment_date BETWEEN g_start_year AND g_end_year
3274: AND period_num = l_payroll_max_period_number;
3275: --

Line 3293: per_time_periods ptp

3289: paa.assignment_action_id),16)),
3290: max(pact.effective_date) effective_date
3291: FROM pay_assignment_actions paa,
3292: pay_payroll_actions pact,
3293: per_time_periods ptp
3294: WHERE paa.assignment_id = p_asgid
3295: AND paa.payroll_action_id = pact.payroll_action_id
3296: AND pact.time_period_id = ptp.time_period_id
3297: AND pact.action_type IN ('Q','R','B','I','V')

Line 3459: ,per_time_periods bptp

3455: ,pay_element_links_f el_ni
3456: ,pay_payroll_actions pact
3457: ,pay_assignment_actions assact
3458: ,pay_payroll_actions bact
3459: ,per_time_periods bptp
3460: ,per_time_periods pptp
3461: ,pay_assignment_actions bal_assact
3462: WHERE bal_assact.assignment_action_id = cp_l_asg_id
3463: AND bal_assact.payroll_action_id = bact.payroll_action_id

Line 3460: ,per_time_periods pptp

3456: ,pay_payroll_actions pact
3457: ,pay_assignment_actions assact
3458: ,pay_payroll_actions bact
3459: ,per_time_periods bptp
3460: ,per_time_periods pptp
3461: ,pay_assignment_actions bal_assact
3462: WHERE bal_assact.assignment_action_id = cp_l_asg_id
3463: AND bal_assact.payroll_action_id = bact.payroll_action_id
3464: AND feed.balance_type_id = bal.balance_type_id