DBA Data[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on PAY_ALL_PAYROLLS_F

Line 2365: pay_all_payrolls_f papf,

2361: ptp.regular_payment_date, /* Bug#8592027 */
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

Line 5917: pay_all_payrolls_f papf,

5913: select ptp.start_date,
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

Line 6006: pay_all_payrolls_f papf

6002:
6003: CURSOR get_number_periods_per_year IS
6004: SELECT number_per_fiscal_year
6005: FROM per_time_period_types pttt,
6006: pay_all_payrolls_f papf
6007: WHERE pttt.period_type=papf.period_type
6008: AND papf.payroll_id=p_payroll_id;
6009:
6010: CURSOR get_assignment_number IS