APPS.CSI_CUSTOMER_PRODUCTS_PKG dependencies on CSI_IP_ACCOUNTS

Line 195: FROM csi_ip_accounts

191: ) IS
192:
193: CURSOR GET_IP_Account IS
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

Line 870: From CSI_IP_ACCOUNTS

866: End;
867: Begin
868: Select Object_Version_Number
869: Into Px_IPA_Object_Version_Number
870: From CSI_IP_ACCOUNTS
871: Where ip_account_id = l_Account_Tbl(1).IP_Account_Id;
872: Exception
873: When Others Then
874: Null;

Line 917: From CSI_IP_ACCOUNTS

913: End;
914: Begin
915: Select Object_Version_Number
916: Into Px_IPA_Object_Version_Number
917: From CSI_IP_ACCOUNTS
918: Where ip_account_id = l_Account_Tbl(1).IP_Account_Id;
919: Exception
920: When Others Then
921: Null;

Line 1180: FROM CSI_IP_ACCOUNTS

1176: FOR UPDATE of INSTANCE_PARTY_ID NOWAIT;
1177: FetchC2 C2%ROWTYPE;
1178: CURSOR C3 IS
1179: SELECT *
1180: FROM CSI_IP_ACCOUNTS
1181: WHERE IP_ACCOUNT_ID = p_IP_ACCOUNT_ID
1182: FOR UPDATE of IP_ACCOUNT_ID NOWAIT;
1183: FetchC3 C3%ROWTYPE;
1184: CURSOR C4 IS