APPS.HR_US_FF_UDF1 dependencies on PER_TIME_PERIODS

Line 440: FROM per_time_periods ptp

436: WHERE paa1.assignment_id = l_assignment_id
437: AND paa1.tax_unit_id = p_tax_unit_id
438: AND paa1.action_sequence =
439: (SELECT max(paa_prev.action_sequence)
440: FROM per_time_periods ptp
441: , pay_payroll_actions ppa
442: , pay_assignment_actions paa
443: , per_time_periods ptp_prev
444: , pay_payroll_actions ppa_prev

Line 443: , per_time_periods ptp_prev

439: (SELECT max(paa_prev.action_sequence)
440: FROM per_time_periods ptp
441: , pay_payroll_actions ppa
442: , pay_assignment_actions paa
443: , per_time_periods ptp_prev
444: , pay_payroll_actions ppa_prev
445: , pay_assignment_actions paa_prev
446: WHERE paa.assignment_action_id = p_assignment_action_id
447: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2313: per_time_periods ptp

2309: select ptp.start_date,
2310: ptp.end_date
2311: from per_all_assignments_f paaf,
2312: pay_all_payrolls_f papf,
2313: per_time_periods ptp
2314: where paaf.payroll_id = papf.payroll_id
2315: and papf.payroll_id = ptp.payroll_id
2316: and assignment_id = p_assignment_id
2317: and p_date_earned between ptp.start_date

Line 2558: FROM per_time_periods

2554: CURSOR csr_time_period(p_time_period_id IN NUMBER,
2555: p_payroll_id IN NUMBER) IS
2556: SELECT end_date,
2557: start_date
2558: FROM per_time_periods
2559: WHERE time_period_id = p_time_period_id
2560: AND payroll_id = p_payroll_id;
2561:
2562:

Line 2569: FROM per_time_periods

2565: CURSOR csr_time_period_prev(p_prev_end_date IN DATE,
2566: p_payroll_id IN NUMBER) IS
2567: SELECT end_date,
2568: start_date
2569: FROM per_time_periods
2570: WHERE end_date = p_prev_end_date
2571: AND payroll_id = p_payroll_id;
2572:
2573: -- Get Work Jurisdiction for the assignment