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 3874: FND_TERRITORIES_VL TERR

3870: SELECT ppt.territory_code,
3871: TERR.territory_short_name
3872: FROM pay_org_payment_methods_f pom,
3873: pay_payment_types ppt,
3874: FND_TERRITORIES_VL TERR
3875: WHERE pom.org_payment_method_id = cp_org_payment_method_id
3876: AND pom.payment_type_id = ppt.payment_type_id
3877: AND ppt.territory_code = TERR.territory_code (+);
3878:

Line 3885: FND_TERRITORIES_VL TERR

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

Line 3893: l_territory_desc FND_TERRITORIES_VL.territory_short_name%TYPE;

3889: AND org_inf.org_information9 = TERR.territory_code (+);
3890:
3891: l_ppt_territory_code pay_payment_types.territory_code%TYPE;
3892: l_bg_country hr_organization_information.org_information9%TYPE;
3893: l_territory_desc FND_TERRITORIES_VL.territory_short_name%TYPE;
3894:
3895: begin
3896: l_ppt_territory_code := null;
3897: l_bg_country := null;