APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on CSI_I_PARTIES

Line 2366: FROM CSI_I_PARTIES

2362: -- Start bug 9823087
2363: /* CURSOR c_instance_party is
2364: SELECT instance_party_id,
2365: relationship_type_code
2366: FROM CSI_I_PARTIES
2367: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2368: --AND relationship_type_code = 'OWNER' -- Bug 8209077
2369: AND party_id = (SELECT party_id
2370: FROM hz_cust_accounts

Line 2376: FROM CSI_I_PARTIES

2372:
2373: CURSOR c_instance_party_owner is
2374: SELECT instance_party_id,
2375: relationship_type_code
2376: FROM CSI_I_PARTIES
2377: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2378: AND relationship_type_code = 'OWNER'
2379: AND party_id = (SELECT party_id
2380: FROM hz_cust_accounts

Line 2386: FROM CSI_I_PARTIES

2382:
2383: CURSOR c_instance_party is
2384: SELECT instance_party_id,
2385: relationship_type_code
2386: FROM CSI_I_PARTIES
2387: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2388: AND relationship_type_code <> 'OWNER'
2389: AND party_id = (SELECT party_id
2390: FROM hz_cust_accounts

Line 2436: FROM CSI_I_PARTIES

2432:
2433: /* BEGIN
2434: SELECT instance_party_id
2435: INTO l_instance_party_id
2436: FROM CSI_I_PARTIES
2437: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2438: AND relationship_type_code = 'OWNER'
2439: AND party_id = (SELECT party_id
2440: FROM hz_cust_accounts

Line 2498: FROM CSI_I_PARTIES

2494:
2495: /*Cursor c_instance_party1 is
2496: SELECT instance_party_id,
2497: relationship_type_code
2498: FROM CSI_I_PARTIES
2499: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2500: --AND relationship_type_code = 'OWNER'
2501: AND party_id IN (l_internal_party_id,EstDtlTab(i).customer_id);*/
2502:

Line 2506: FROM CSI_I_PARTIES

2502:
2503: Cursor c_instance_party1_owner is
2504: SELECT instance_party_id,
2505: relationship_type_code
2506: FROM CSI_I_PARTIES
2507: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2508: AND relationship_type_code = 'OWNER'
2509: AND party_id IN (l_internal_party_id,EstDtlTab(i).customer_id);
2510:

Line 2515: FROM CSI_I_PARTIES

2511:
2512: Cursor c_instance_party1 is
2513: SELECT instance_party_id,
2514: relationship_type_code
2515: FROM CSI_I_PARTIES
2516: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2517: AND relationship_type_code <> 'OWNER'
2518: AND party_id IN (l_internal_party_id,EstDtlTab(i).customer_id);
2519: -- End bug 9823087

Line 2560: FROM CSI_I_PARTIES

2556: /* BEGIN
2557: IF EstDtlTab(i).Customer_Product_Id is not NULL THEN
2558: SELECT instance_party_id
2559: INTO l_instance_party_id
2560: FROM CSI_I_PARTIES
2561: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2562: AND relationship_type_code = 'OWNER'
2563: AND party_id IN (l_internal_party_id,EstDtlTab(i).customer_id);*/
2564: ELSE

Line 3421: FROM CSI_I_PARTIES

3417: END;
3418:
3419: SELECT instance_party_id
3420: INTO l_instance_party_id
3421: FROM CSI_I_PARTIES
3422: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
3423: AND relationship_type_code = 'OWNER'
3424: AND party_id = (SELECT party_id
3425: FROM hz_cust_accounts