[Home] [Help]
APPS.PAY_PPMV4_SS dependencies on HR_ALL_ORGANIZATION_UNITS
Line 3883: FROM hr_all_organization_units org,
3879: cursor c_get_bg_country (
3880: cp_business_group_id number) IS
3881: SELECT org_inf.org_information9,
3882: TERR.territory_short_name
3883: FROM hr_all_organization_units org,
3884: hr_organization_information org_inf,
3885: FND_TERRITORIES_VL TERR
3886: WHERE org.ORGANIZATION_ID = cp_business_group_id
3887: AND org.ORGANIZATION_ID = org_inf.ORGANIZATION_ID