DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on HR_FR_ESTABLISHMENTS_V

Line 749: from hr_fr_establishments_v

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

Line 756: from hr_fr_establishments_v

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