DBA Data[Home] [Help]

APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on CSM_PARTIES_ACC

Line 150: --doesnot have the corresponding party_id in the CSM_PARTIES_ACC Table.

146:
147: --PROCEDURE IMPLEMENTATION DETAILS
148: --While deleting the records from access table we are not considering the counter value
149: --in the access table this is because we do delete only for the accounts which
150: --doesnot have the corresponding party_id in the CSM_PARTIES_ACC Table.
151: --ie.The Delete depends only the pary acccess table.This delete procedure is called
152: --whenever the pary delete is called
153: PROCEDURE CUST_ACCOUNTS_DEL (p_party_id NUMBER , p_user_id NUMBER)
154: IS

Line 164: FROM CSM_PARTIES_ACC acc

160: WHERE acc.USER_ID = c_user_id
161: AND NOT EXISTS
162: (
163: SELECT 1
164: FROM CSM_PARTIES_ACC acc
165: WHERE acc.USER_ID = c_user_id
166: AND acc.party_ID = c_party_id
167: );
168: