APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on HZ_PARTY_SITES

Line 30: , hz_party_sites s

26: , s.end_date_active
27: FROM jtf_rs_resource_extns_vl r
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

Line 57: , hz_party_sites s

53: , l.geometry
54: , s.start_date_active
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 (+)

Line 82: , hz_party_sites s

78: , l.geometry
79: , s.start_date_active
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

Line 108: hz_party_sites hps,

104: , hzl.geometry
105: , hps.start_date_active
106: , hps.end_date_active
107: from hz_locations hzl,
108: hz_party_sites hps,
109: hz_cust_acct_sites hzacs,
110: hz_cust_site_uses hzacus,
111: hz_parties hp,
112: hz_cust_accounts hzca,

Line 990: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);

986: FROM dual;
987: END IF;
988:
989: IF l_debug THEN
990: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
991: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
992: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
993: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
994: END IF;

Line 1505: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);

1501: FROM dual;
1502: END IF;
1503:
1504: IF l_debug THEN
1505: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
1506: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
1507: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
1508: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
1509: END IF;

Line 1619: , hz_party_sites hps

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(+)
1623: AND hl.country = t.territory_code(+)