DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_ALL_PAYROLLS_F

Line 2855: l_payroll pay_all_payrolls_f.payroll_name%type;

2851: l_etp_employee_start_date per_periods_of_service.date_start%type;
2852: l_etp_death_benefit per_periods_of_service.leaving_reason%type;
2853: l_asgmnt_loc hr_locations.location_code%type;
2854: l_emp_no per_all_people_f.employee_number%type;
2855: l_payroll pay_all_payrolls_f.payroll_name%type;
2856: l_emp_type per_all_people_f.current_employee_flag%type;
2857: l_address_date_from date;
2858:
2859: -----------------------------------------------------------------------------------------------+

Line 3763: l_payroll pay_all_payrolls_f.payroll_name%type;

3759: l_termination_date VARCHAR2(20);
3760: l_dob VARCHAR2(20);
3761: l_asgmnt_loc hr_locations.location_code%type;
3762: l_emp_no per_all_people_f.employee_number%type;
3763: l_payroll pay_all_payrolls_f.payroll_name%type;
3764: l_emp_type per_all_people_f.current_employee_flag%type;
3765: l_address_date_from date;
3766: l_date_earned pay_payroll_actions.date_earned%type;
3767: l_effective_date date; -- Bug3263659

Line 4641: pay_all_payrolls_f papf, --4281290

4637: pps.final_process_date final_process_date --3263659
4638: from per_all_people_f p,
4639: per_all_assignments_f a,
4640: per_periods_of_service pps,
4641: pay_all_payrolls_f papf, --4281290
4642: pay_payroll_actions pa,
4643: pay_assignment_actions ppa
4644: where a.person_id = p.person_id
4645: and pps.person_id = p.person_id