DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_RS_CUST_RELATIONS

Line 183: from csp_rs_cust_relations rcr,

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

Line 202: from csp_rs_cust_relations rcr,

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