APPS.HZ_ACCOUNT_MERGE_PUB dependencies on RA_CUSTOMER_MERGE_HEADERS

Line 935: from ra_customer_merges cm, ra_customer_merge_headers cmh , hz_cust_acct_sites_all cas

931: l_exist := 'N';
932:
933: select 'Y' , cmh.duplicate_number, cmh.customer_number
934: into l_exist, tmp_duplicate_number, tmp_customer_number
935: from ra_customer_merges cm, ra_customer_merge_headers cmh , hz_cust_acct_sites_all cas
936: where cas.cust_account_id = cm.duplicate_id
937: and (cmh.process_flag NOT IN ('FAILED' ,'Y','DISCARD') )
938: and cmh.customer_merge_header_id = cm.customer_merge_header_id
939: and cas.cust_account_id = l_account_merge_request_obj.merge_from_account.account_id

Line 1311: l_header_id := ra_customer_merge_headers_s.nextval;

1307: --END Validation
1308:
1309: /* Insert Merge header */
1310:
1311: l_header_id := ra_customer_merge_headers_s.nextval;
1312:
1313: --Populate ra_customer_merge_headers
1314:
1315: INSERT INTO RA_CUSTOMER_MERGE_HEADERS(

Line 1313: --Populate ra_customer_merge_headers

1309: /* Insert Merge header */
1310:
1311: l_header_id := ra_customer_merge_headers_s.nextval;
1312:
1313: --Populate ra_customer_merge_headers
1314:
1315: INSERT INTO RA_CUSTOMER_MERGE_HEADERS(
1316: CUSTOMER_MERGE_HEADER_ID
1317: , CREATION_DATE

Line 1315: INSERT INTO RA_CUSTOMER_MERGE_HEADERS(

1311: l_header_id := ra_customer_merge_headers_s.nextval;
1312:
1313: --Populate ra_customer_merge_headers
1314:
1315: INSERT INTO RA_CUSTOMER_MERGE_HEADERS(
1316: CUSTOMER_MERGE_HEADER_ID
1317: , CREATION_DATE
1318: , CREATED_BY
1319: , LAST_UPDATE_DATE

Line 1865: UPDATE ra_customer_merge_headers

1861: '','','','','','','','','','',
1862: '','','','','','','','','' );
1863: IF x_account_merge_request_id > 0 THEN
1864:
1865: UPDATE ra_customer_merge_headers
1866: SET request_id = x_account_merge_request_id
1867: WHERE customer_merge_header_id = l_header_id;
1868:
1869: UPDATE ra_customer_merges