APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_ALL_PAYROLLS_F

Line 5133: l_payroll pay_all_payrolls_f.payroll_name%type;

5129: l_etp_employee_start_date per_periods_of_service.date_start%type;
5130: l_etp_death_benefit per_periods_of_service.leaving_reason%type;
5131: l_asgmnt_loc hr_locations.location_code%type;
5132: l_emp_no per_all_people_f.employee_number%type;
5133: l_payroll pay_all_payrolls_f.payroll_name%type;
5134: l_emp_type per_all_people_f.current_employee_flag%type;
5135: l_address_date_from date;
5136:
5137: -----------------------------------------------------------------------------------------------+

Line 7206: l_payroll pay_all_payrolls_f.payroll_name%type;

7202: l_termination_date VARCHAR2(20);
7203: l_dob VARCHAR2(20);
7204: l_asgmnt_loc hr_locations.location_code%type;
7205: l_emp_no per_all_people_f.employee_number%type;
7206: l_payroll pay_all_payrolls_f.payroll_name%type;
7207: l_emp_type per_all_people_f.current_employee_flag%type;
7208: l_address_date_from date;
7209: l_date_earned pay_payroll_actions.date_earned%type;
7210: l_effective_date date; -- Bug3263659

Line 8106: pay_all_payrolls_f papf, --4281290

8102: pps.final_process_date final_process_date --3263659
8103: from per_all_people_f p,
8104: per_all_assignments_f a,
8105: per_periods_of_service pps,
8106: pay_all_payrolls_f papf, --4281290
8107: pay_payroll_actions pa,
8108: pay_assignment_actions ppa
8109: where a.person_id = p.person_id
8110: and pps.person_id = p.person_id