DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on HR_ORGANIZATION_UNITS

Line 484: , hr_organization_units hou

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
488: AND paf.job_id = pj.job_id(+)

Line 506: from hr_organization_units hou

502: --
503: CURSOR get_org_payee_details(p_organization_id in number)
504: IS
505: SELECT hou.name
506: from hr_organization_units hou
507: WHERE hou.organization_id=p_organization_id;
508:
509: CURSOR get_payroll_details(p_prepru_pact_id in number)
510: IS

Line 636: l_employer hr_organization_units.name%TYPE;

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);
640: l_assignment_action_id number;