APPS.HR_US_FF_UDF1 dependencies on PER_TIME_PERIODS

Line 481: FROM per_time_periods ptp

477: WHERE paa1.assignment_id = l_assignment_id
478: AND paa1.tax_unit_id = p_tax_unit_id
479: AND paa1.action_sequence =
480: (SELECT max(paa_prev.action_sequence)
481: FROM per_time_periods ptp
482: , pay_payroll_actions ppa
483: , pay_assignment_actions paa
484: , per_time_periods ptp_prev
485: , pay_payroll_actions ppa_prev

Line 484: , per_time_periods ptp_prev

480: (SELECT max(paa_prev.action_sequence)
481: FROM per_time_periods ptp
482: , pay_payroll_actions ppa
483: , pay_assignment_actions paa
484: , per_time_periods ptp_prev
485: , pay_payroll_actions ppa_prev
486: , pay_assignment_actions paa_prev
487: WHERE paa.assignment_action_id = p_assignment_action_id
488: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2366: per_time_periods ptp

2362: ptp.payroll_id, /*7520832*/
2363: paaf.person_id /* 765549 */
2364: from per_all_assignments_f paaf,
2365: pay_all_payrolls_f papf,
2366: per_time_periods ptp
2367: where paaf.payroll_id = papf.payroll_id
2368: and papf.payroll_id = ptp.payroll_id
2369: and assignment_id = p_assignment_id
2370: and p_date_earned between ptp.start_date

Line 2390: from per_time_periods

2386:
2387: /*7520832: Cursor to fetch nearest pay period to the WC effective date*/
2388: CURSOR CSR_GET_NEAREST_PERIOD IS
2389: select max(nvl(regular_payment_date,end_date))
2390: from per_time_periods
2391: where payroll_id = l_payroll_id
2392: and nvl(regular_payment_date,end_date) <= l_date;
2393:
2394: BEGIN

Line 2657: FROM per_time_periods

2653: CURSOR csr_time_period(p_time_period_id IN NUMBER,
2654: p_payroll_id IN NUMBER) IS
2655: SELECT end_date,
2656: start_date
2657: FROM per_time_periods
2658: WHERE time_period_id = p_time_period_id
2659: AND payroll_id = p_payroll_id;
2660:
2661:

Line 2668: FROM per_time_periods

2664: CURSOR csr_time_period_prev(p_prev_end_date IN DATE,
2665: p_payroll_id IN NUMBER) IS
2666: SELECT end_date,
2667: start_date
2668: FROM per_time_periods
2669: WHERE end_date = p_prev_end_date
2670: AND payroll_id = p_payroll_id;
2671:
2672: -- Get Work Jurisdiction for the assignment

Line 5918: per_time_periods ptp

5914: ptp.end_date,
5915: ptp.payroll_id
5916: from per_all_assignments_f paaf,
5917: pay_all_payrolls_f papf,
5918: per_time_periods ptp
5919: where paaf.payroll_id = papf.payroll_id
5920: and papf.payroll_id = ptp.payroll_id
5921: and assignment_id = p_assignment_id
5922: and p_date_earned between ptp.start_date

Line 5932: from per_time_periods

5928:
5929: --Cursor to fetch nearest pay period to the WC effective date
5930: CURSOR CSR_GET_NEAREST_PERIOD IS
5931: select max(end_date)
5932: from per_time_periods
5933: where payroll_id = l_payroll_id
5934: and end_date <= l_date;
5935:
5936: --Cursor to fetch the average percentage of employee's time in each of

Line 6217: per_time_periods target

6213:
6214: CURSOR get_count IS
6215: SELECT decode(count(regular_payment_date),0,1,count(regular_payment_date))
6216: FROM pay_payroll_actions paction,
6217: per_time_periods target
6218: WHERE paction.payroll_action_id = p_payroll_action_id
6219: AND target.payroll_id = paction.payroll_id
6220: AND to_char(target.regular_payment_date,'YYYY')=to_char(paction.effective_date,'YYYY')
6221: AND target.regular_payment_date >= p_logical_hire_date;