DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on CSI_I_PARTIES

Line 2121: FROM CSI_I_PARTIES

2117:
2118: BEGIN
2119: SELECT instance_party_id
2120: INTO l_instance_party_id
2121: FROM CSI_I_PARTIES
2122: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2123: AND relationship_type_code = 'OWNER'
2124: AND party_id = (SELECT party_id
2125: FROM hz_cust_accounts

Line 2181: FROM CSI_I_PARTIES

2177: BEGIN
2178: IF EstDtlTab(i).Customer_Product_Id is not NULL THEN
2179: SELECT instance_party_id
2180: INTO l_instance_party_id
2181: FROM CSI_I_PARTIES
2182: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2183: AND relationship_type_code = 'OWNER'
2184: AND party_id IN (l_internal_party_id,EstDtlTab(i).customer_id);
2185: ELSE

Line 2849: FROM CSI_I_PARTIES

2845: END;
2846:
2847: SELECT instance_party_id
2848: INTO l_instance_party_id
2849: FROM CSI_I_PARTIES
2850: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2851: AND relationship_type_code = 'OWNER'
2852: AND party_id = (SELECT party_id
2853: FROM hz_cust_accounts