APPS.CSD_MIGRATE_FROM_12X_PKG9 dependencies on CSD_REPAIRS

Line 18: OF CSD_REPAIRS.CUSTOMER_PRODUCT_ID%TYPE;

14: -- Definitions --
15: TYPE W_CONTRACT_XREF_ID_ARRAY_TYPE IS VARRAY (1000)
16: OF CSD_AHL_W_CONTRACT_XREF.WARRANTY_CONTRACT_XREF_ID%TYPE;
17: TYPE INSTANCE_ID_ARRAY_TYPE IS VARRAY (1000)
18: OF CSD_REPAIRS.CUSTOMER_PRODUCT_ID%TYPE;
19:
20: -- Variables --
21: w_contract_xref_id_arr W_CONTRACT_XREF_ID_ARRAY_TYPE;
22: instance_id_arr INSTANCE_ID_ARRAY_TYPE;

Line 39: CSD_REPAIRS rep

35: SELECT DISTINCT
36: wc.warranty_contract_xref_id, rep.customer_product_id
37: FROM
38: CSD_AHL_W_CONTRACT_XREF wc,
39: CSD_REPAIRS rep
40: WHERE wc.instance_id IS NULL
41: AND rep.repair_line_id = wc.repair_line_id;
42:
43: BEGIN