DBA Data[Home] [Help]

APPS.PAY_PL_UTILITY dependencies on PAY_ALL_PAYROLLS_F

Line 53: pay_all_payrolls_f papf,

49: from per_all_assignments_f paaf1,
50: per_assignment_status_types past1,
51: per_all_assignments_f paaf2,
52: per_assignment_status_types past2,
53: pay_all_payrolls_f papf,
54: per_time_periods ptp
55: where past1.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
56: and paaf1.assignment_status_type_id=past1.assignment_status_type_id
57: and paaf1.assignment_id=p_assignment_id

Line 339: pay_all_payrolls_f papf,

335: from per_all_assignments_f paaf1,
336: per_assignment_status_types past1,
337: per_all_assignments_f paaf2,
338: per_assignment_status_types past2,
339: pay_all_payrolls_f papf,
340: per_time_periods ptp
341: where past1.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
342: and paaf1.assignment_status_type_id=past1.assignment_status_type_id
343: and paaf1.assignment_id=p_assignment_id

Line 360: pay_all_payrolls_f papf,

356: select 'Y' payroll_run,paa.assignment_action_id ,ppa.date_earned
357: from pay_payroll_actions ppa,
358: pay_Assignment_actions paa,
359: per_time_periods ptp,
360: pay_all_payrolls_f papf,
361: pay_run_results prr,
362: pay_element_types_f petf
363: where paa.source_action_id is not null
364: and paa.assignment_id=r_assignment_id