APPS.AMW_LOAD_KEY_ACC_DATA dependencies on AMW_ACCT_ASSOCIATIONS

Line 124: from amw_acct_associations

120: AND rownum = 1;
121:
122: cursor c_key_acc_exists(p_process_id in number, p_natural_account_id in number) is
123: select acct_assoc_id
124: from amw_acct_associations
125: where object_type = 'PROCESS'
126: and pk1 = p_process_id
127: and natural_account_id = p_natural_account_id;
128:

Line 272: FROM AMW_ACCT_ASSOCIATIONS

268: L_APPROVAL_DATE := NULL;
269: BEGIN
270: SELECT ACCT_ASSOC_ID, APPROVAL_DATE
271: INTO L_ACCT_ASSOCIATION_ID,L_APPROVAL_DATE
272: FROM AMW_ACCT_ASSOCIATIONS
273: WHERE OBJECT_TYPE='PROCESS'
274: AND PK1=l_process_id
275: AND NATURAL_ACCOUNT_ID=l_natural_account_id
276: AND DELETION_DATE IS NULL;

Line 315: UPDATE AMW_ACCT_ASSOCIATIONS

311: IF(L_APPROVAL_DATE IS NOT NULL) THEN
312: --THIS MEANS THAT THIS IS LATEST REVISION FOR THIS ASSOCIATION
313: --AND IS APPROVED, SO
314: BEGIN
315: UPDATE AMW_ACCT_ASSOCIATIONS
316: SET DELETION_DATE=SYSDATE
317: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
318: ,LAST_UPDATE_DATE=SYSDATE
319: ,LAST_UPDATED_BY=G_USER_ID

Line 418: INSERT INTO amw_acct_associations(

414: )
415: IS
416:
417: BEGIN
418: INSERT INTO amw_acct_associations(
419: acct_assoc_id
420: ,last_update_date
421: ,last_updated_by
422: ,creation_date

Line 431: amw_acct_associations_s.NEXTVAL

427: ,pk1
428: ,object_type
429: ,object_version_number
430: )VALUES (
431: amw_acct_associations_s.NEXTVAL
432: ,SYSDATE
433: ,v_user_id
434: ,SYSDATE
435: ,v_user_id