eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PPMV4_SS dependencies on FND_TERRITORIES_VL

Line 3538: FND_TERRITORIES_VL TERR

3534: SELECT ppt.territory_code,
3535: TERR.territory_short_name
3536: FROM pay_org_payment_methods_f pom,
3537: pay_payment_types ppt,
3538: FND_TERRITORIES_VL TERR
3539: WHERE pom.org_payment_method_id = cp_org_payment_method_id
3540: AND pom.payment_type_id = ppt.payment_type_id
3541: AND ppt.territory_code = TERR.territory_code (+);
3542:

Line 3549: FND_TERRITORIES_VL TERR

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
3552: AND ORG_INFORMATION_CONTEXT = 'Business Group Information'
3553: AND org_inf.org_information9 = TERR.territory_code (+);

Line 3557: l_territory_desc FND_TERRITORIES_VL.territory_short_name%TYPE;

3553: AND org_inf.org_information9 = TERR.territory_code (+);
3554:
3555: l_ppt_territory_code pay_payment_types.territory_code%TYPE;
3556: l_bg_country hr_organization_information.org_information9%TYPE;
3557: l_territory_desc FND_TERRITORIES_VL.territory_short_name%TYPE;
3558:
3559: begin
3560: l_ppt_territory_code := null;
3561: l_bg_country := null;