DBA Data[Home] [Help]

APPS.CSI_CUSTOMER_PRODUCTS_PKG dependencies on CSI_I_PARTIES

Line 198: FROM csi_i_parties

194: SELECT ip_account_id
195: FROM csi_ip_accounts
196: WHERE party_account_id = p_customer_id
197: AND instance_party_id = (SELECT instance_party_id
198: FROM csi_i_parties
199: WHERE instance_id = p_customer_product_id
200: AND relationship_type_code = 'OWNER');
201:
202: BEGIN

Line 1174: FROM CSI_I_PARTIES

1170: FOR UPDATE of INSTANCE_ID NOWAIT;
1171: FetchC1 C1%ROWTYPE;
1172: CURSOR C2 IS
1173: SELECT *
1174: FROM CSI_I_PARTIES
1175: WHERE INSTANCE_PARTY_ID = p_INSTANCE_PARTY_ID
1176: FOR UPDATE of INSTANCE_PARTY_ID NOWAIT;
1177: FetchC2 C2%ROWTYPE;
1178: CURSOR C3 IS