APPS.HZ_MERGE_PKG dependencies on HZ_DNB_REQUEST_LOG

Line 6765: --Insert a row in HZ_DNB_REQUEST_LOG table.

6761: l_duns_number NUMBER;
6762:
6763: BEGIN
6764:
6765: --Insert a row in HZ_DNB_REQUEST_LOG table.
6766: SELECT requested_product, duns_number
6767: INTO l_requested_product, l_duns_number
6768: FROM hz_dnb_request_log
6769: WHERE party_id = p_source_party_id

Line 6768: FROM hz_dnb_request_log

6764:
6765: --Insert a row in HZ_DNB_REQUEST_LOG table.
6766: SELECT requested_product, duns_number
6767: INTO l_requested_product, l_duns_number
6768: FROM hz_dnb_request_log
6769: WHERE party_id = p_source_party_id
6770: AND request_id = (
6771: SELECT MAX(request_id)
6772: FROM hz_dnb_request_log

Line 6772: FROM hz_dnb_request_log

6768: FROM hz_dnb_request_log
6769: WHERE party_id = p_source_party_id
6770: AND request_id = (
6771: SELECT MAX(request_id)
6772: FROM hz_dnb_request_log
6773: WHERE party_id = p_source_party_id
6774: AND status = 'S' );
6775:
6776: INSERT INTO hz_dnb_request_log(

Line 6776: INSERT INTO hz_dnb_request_log(

6772: FROM hz_dnb_request_log
6773: WHERE party_id = p_source_party_id
6774: AND status = 'S' );
6775:
6776: INSERT INTO hz_dnb_request_log(
6777: REQUEST_ID,
6778: PARTY_ID,
6779: REQUESTED_PRODUCT,
6780: DUNS_NUMBER,

Line 6789: HZ_DNB_REQUEST_LOG_S.nextval,

6785: LAST_UPDATE_DATE,
6786: LAST_UPDATE_LOGIN,
6787: COPIED_FROM_PARTY_ID )
6788: VALUES(
6789: HZ_DNB_REQUEST_LOG_S.nextval,
6790: p_destination_party_id,
6791: l_requested_product,
6792: l_duns_number,
6793: 'S',