APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on FND_TERRITORIES

Line 32: , fnd_territories_vl t

28: , per_people_f pf
29: , hz_parties p
30: , hz_party_sites s
31: , hz_locations l
32: , fnd_territories_vl t
33: WHERE r.resource_id = :resource_id
34: AND pf.person_id = r.source_id
35: AND pf.party_id = p.party_id (+)
36: AND p.party_id = s.party_id (+)

Line 59: , fnd_territories_vl t

55: , s.end_date_active
56: FROM jtf_rs_resource_extns_vl r
57: , hz_party_sites s
58: , hz_locations l
59: , fnd_territories_vl t
60: WHERE r.resource_id = :resource_id
61: AND r.source_id = s.party_id (+)
62: AND NVL(s.status, ''A'') = ''A''
63: AND s.location_id = l.location_id (+)

Line 84: , fnd_territories_vl t

80: , s.end_date_active
81: FROM hz_parties p
82: , hz_party_sites s
83: , hz_locations l
84: , fnd_territories_vl t
85: WHERE p.person_last_name = :res_type_id_string
86: AND p.person_first_name = :dep_arr_party_name
87: AND s.party_id = p.party_id
88: AND l.location_id = s.location_id

Line 114: ,fnd_territories_vl t

110: hz_cust_site_uses hzacus,
111: hz_parties hp,
112: hz_cust_accounts hzca,
113: csp_rs_cust_relations ccr
114: ,fnd_territories_vl t
115: where hzl.location_id =hps.location_id
116: and hzl.country = t.territory_code(+)
117: and hps.party_id=hp.party_id
118: and hzacs.party_site_id=hps.party_site_id

Line 753: , fnd_territories_vl t

749: , a.date_from start_date_active
750: , a.date_to end_date_active
751: FROM per_addresses a
752: , jtf_rs_resource_extns r
753: , fnd_territories_vl t
754: WHERE r.resource_id = b_resource_id
755: AND a.person_id = r.source_id
756: AND a.country = t.territory_code
757: AND TRUNC(a.date_from) <= TRUNC(b_date)

Line 852: SELECT territory_code FROM fnd_territories WHERE ROWNUM = 1;

848: l_party_site_number VARCHAR2(30);
849:
850: -- Get an arbitrary country (territory) code
851: CURSOR c_terr IS
852: SELECT territory_code FROM fnd_territories WHERE ROWNUM = 1;
853: BEGIN
854: IF l_debug THEN
855: debug('Creating the Resource Party Link for Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);
856: END IF;

Line 1351: SELECT territory_code FROM fnd_territories WHERE ROWNUM = 1;

1347: l_party_site_number VARCHAR2(30);
1348:
1349: -- Get an arbitrary country (territory) code
1350: CURSOR c_terr IS
1351: SELECT territory_code FROM fnd_territories WHERE ROWNUM = 1;
1352:
1353:
1354: BEGIN
1355: IF l_debug THEN

Line 1618: , fnd_territories_vl t

1614: HPS.START_DATE_ACTIVE,
1615: HPS.END_DATE_ACTIVE
1616: FROM csp_rs_cust_relations csc
1617: , hz_locations hl
1618: , fnd_territories_vl t
1619: , hz_party_sites hps
1620: WHERE csc.resource_id=p_resource_id
1621: AND csc.resource_type = p_resource_type
1622: AND csc.default_trip_start = hl.location_id(+)