DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on PER_JOBS

Line 483: , per_jobs pj

479: , paf.assignment_number
480: FROM per_all_assignments_f paf
481: , per_all_people_f ppf
482: , per_periods_of_service pps
483: , per_jobs pj
484: , hr_organization_units hou
485: , pay_payrolls_f prl
486: WHERE paf.person_id = ppf.person_id
487: and paf.assignment_id = p_assignment_id

Line 635: l_job per_jobs.name%TYPE;

631: l_payroll_end_date date;
632: l_cheque_no varchar2(30);
633: l_effective_date date;
634: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
635: l_job per_jobs.name%TYPE;
636: l_employer hr_organization_units.name%TYPE;
637: l_payroll_id number;
638: l_chq_effective_date varchar2(30);
639: l_deposit_date varchar2(30);