DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_RS_CUST_RELATIONS

Line 180: from csp_rs_cust_relations rcr,

176:
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,

Line 199: from csp_rs_cust_relations rcr,

195:
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,