DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 395: FROM hr_organization_units o1

391: lr_local_unit_id csr_local_unit_id%ROWTYPE;
392:
393: CURSOR csr_legal_employer_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
394: SELECT hoi3.organization_id legal_employer_id
395: FROM hr_organization_units o1
396: , hr_organization_information hoi1
397: , hr_organization_information hoi2
398: , hr_organization_information hoi3
399: WHERE o1.business_group_id =p_business_group_id