APPS.HZ_MERGE_PKG dependencies on HZ_DNB_REQUEST_LOG

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

6889: l_duns_number NUMBER;
6890:
6891: BEGIN
6892:
6893: --Insert a row in HZ_DNB_REQUEST_LOG table.
6894: SELECT requested_product, duns_number
6895: INTO l_requested_product, l_duns_number
6896: FROM hz_dnb_request_log
6897: WHERE party_id = p_source_party_id

Line 6896: FROM hz_dnb_request_log

6892:
6893: --Insert a row in HZ_DNB_REQUEST_LOG table.
6894: SELECT requested_product, duns_number
6895: INTO l_requested_product, l_duns_number
6896: FROM hz_dnb_request_log
6897: WHERE party_id = p_source_party_id
6898: AND request_id = (
6899: SELECT MAX(request_id)
6900: FROM hz_dnb_request_log

Line 6900: FROM hz_dnb_request_log

6896: FROM hz_dnb_request_log
6897: WHERE party_id = p_source_party_id
6898: AND request_id = (
6899: SELECT MAX(request_id)
6900: FROM hz_dnb_request_log
6901: WHERE party_id = p_source_party_id
6902: AND status = 'S' );
6903:
6904: INSERT INTO hz_dnb_request_log(

Line 6904: INSERT INTO hz_dnb_request_log(

6900: FROM hz_dnb_request_log
6901: WHERE party_id = p_source_party_id
6902: AND status = 'S' );
6903:
6904: INSERT INTO hz_dnb_request_log(
6905: REQUEST_ID,
6906: PARTY_ID,
6907: REQUESTED_PRODUCT,
6908: DUNS_NUMBER,

Line 6917: HZ_DNB_REQUEST_LOG_S.nextval,

6913: LAST_UPDATE_DATE,
6914: LAST_UPDATE_LOGIN,
6915: COPIED_FROM_PARTY_ID )
6916: VALUES(
6917: HZ_DNB_REQUEST_LOG_S.nextval,
6918: p_destination_party_id,
6919: l_requested_product,
6920: l_duns_number,
6921: 'S',