APPS.OKC_HZ_MERGE_PUB dependencies on RA_CUSTOMER_MERGE_HEADERS

Line 2437: FROM ra_customer_merge_headers cmh

2433: -- to be used later
2434: --
2435: CURSOR c_reason IS
2436: SELECT cmh.merge_reason_code
2437: FROM ra_customer_merge_headers cmh
2438: ,ra_customer_merges cme
2439: WHERE cmh.customer_merge_header_id = cme.customer_merge_header_id
2440: AND cme.request_id = req_id
2441: AND cme.set_number = set_number

Line 2498: l_merge_reason ra_customer_merge_headers.merge_reason_code%type;

2494: ;
2495: --
2496: -- local variables
2497: --
2498: l_merge_reason ra_customer_merge_headers.merge_reason_code%type;
2499: l_customer_id ra_customer_merge_headers.customer_id%type;
2500: l_duplicate_id ra_customer_merge_headers.duplicate_id%type;
2501: l_source_party_id hz_parties.party_id%type;
2502: l_target_party_id hz_parties.party_id%type;

Line 2499: l_customer_id ra_customer_merge_headers.customer_id%type;

2495: --
2496: -- local variables
2497: --
2498: l_merge_reason ra_customer_merge_headers.merge_reason_code%type;
2499: l_customer_id ra_customer_merge_headers.customer_id%type;
2500: l_duplicate_id ra_customer_merge_headers.duplicate_id%type;
2501: l_source_party_id hz_parties.party_id%type;
2502: l_target_party_id hz_parties.party_id%type;
2503: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;

Line 2500: l_duplicate_id ra_customer_merge_headers.duplicate_id%type;

2496: -- local variables
2497: --
2498: l_merge_reason ra_customer_merge_headers.merge_reason_code%type;
2499: l_customer_id ra_customer_merge_headers.customer_id%type;
2500: l_duplicate_id ra_customer_merge_headers.duplicate_id%type;
2501: l_source_party_id hz_parties.party_id%type;
2502: l_target_party_id hz_parties.party_id%type;
2503: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
2504: l_error_msg VARCHAR2(2000);