DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on HR_FR_ESTABLISHMENTS_V

Line 747: from hr_fr_establishments_v

743: ,p_establishment_id number
744: ) is
745: select upper(name) tax_unit_name,
746: ORGANIZATION_ID tax_unit_id
747: from hr_fr_establishments_v
748: where business_group_id = p_business_group_id
749: and p_establishment_id = ORGANIZATION_ID
750: and p_establishment_id is not null
751: union all

Line 754: from hr_fr_establishments_v

750: and p_establishment_id is not null
751: union all
752: select upper(name) tax_unit_name,
753: ORGANIZATION_ID tax_unit_id
754: from hr_fr_establishments_v
755: where business_group_id = p_business_group_id
756: and upper(name) = upper(p_name)
757: and p_establishment_id is null;
758: --