DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on HZ_CUST_ACCT_SITES

Line 181: hz_cust_acct_sites cas,

177: CURSOR rs_loc_cur(p_resource_type VARCHAR2, p_resource_id NUMBER) IS
178: SELECT pla.location_id inv_loc_id,
179: hzl.time_zone
180: from csp_rs_cust_relations rcr,
181: hz_cust_acct_sites cas,
182: hz_cust_site_uses csu,
183: po_location_associations pla,
184: hz_party_sites ps,
185: hz_locations hzl

Line 200: hz_cust_acct_sites cas,

196: CURSOR task_asgnmt_loc_cur(p_task_Assignment_id NUMBER) IS
197: SELECT pla.location_id inv_loc_id,
198: hzl.time_zone timezone_id
199: from csp_rs_cust_relations rcr,
200: hz_cust_acct_sites cas,
201: hz_cust_site_uses csu,
202: po_location_associations pla,
203: hz_party_sites ps,
204: hz_locations hzl,

Line 350: from hz_cust_acct_sites cas,

346: ELSE
347: BEGIN
348: SELECT hzl.time_zone time_zone_id
349: INTO l_timezone_id
350: from hz_cust_acct_sites cas,
351: hz_cust_site_uses csu,
352: po_location_associations pla,
353: hz_party_sites ps,
354: hz_locations hzl