[Home] [Help]
APPS.PAY_PPMV4_SS dependencies on HR_ALL_ORGANIZATION_UNITS
Line 3547: FROM hr_all_organization_units org,
3543: cursor c_get_bg_country (
3544: cp_business_group_id number) IS
3545: SELECT org_inf.org_information9,
3546: TERR.territory_short_name
3547: FROM hr_all_organization_units org,
3548: hr_organization_information org_inf,
3549: FND_TERRITORIES_VL TERR
3550: WHERE org.ORGANIZATION_ID = cp_business_group_id
3551: AND org.ORGANIZATION_ID = org_inf.ORGANIZATION_ID