APPS.HZ_PARTY_MERGE dependencies on HZ_FINANCIAL_REPORTS

Line 4089: -- Handle DNB data in HZ_FINANCIAL_REPORTS

4085: END;
4086: END LOOP;
4087:
4088: -- *******************************************
4089: -- Handle DNB data in HZ_FINANCIAL_REPORTS
4090: FOR FROM_FR IN (
4091: SELECT financial_report_id,
4092: type_of_financial_report,
4093: TO_CHAR(DATE_REPORT_ISSUED, 'DD/MM/YYYY') ||

Line 4099: FROM HZ_FINANCIAL_REPORTS

4095: ISSUED_PERIOD ||
4096: TO_CHAR(REPORT_START_DATE, 'DD/MM/YYYY') ||
4097: TO_CHAR(REPORT_END_DATE, 'DD/MM/YYYY') ||
4098: actual_content_source con_cat --for bug 6600935
4099: FROM HZ_FINANCIAL_REPORTS
4100: WHERE actual_content_source = 'DNB'
4101: AND nvl(status, 'A') = 'A'
4102: AND party_id = p_from_id) LOOP
4103:

Line 4106: FROM HZ_FINANCIAL_REPORTS

4102: AND party_id = p_from_id) LOOP
4103:
4104: BEGIN
4105: SELECT financial_report_id INTO l_to
4106: FROM HZ_FINANCIAL_REPORTS
4107: WHERE actual_content_source = 'DNB'
4108: AND nvl(status, 'A') = 'A'
4109: AND type_of_financial_report=FROM_FR.type_of_financial_report
4110: AND TO_CHAR(DATE_REPORT_ISSUED, 'DD/MM/YYYY') ||

Line 4121: DELETE FROM HZ_FINANCIAL_REPORTS

4117:
4118: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
4119:
4120: /*Bug 3236556*/
4121: DELETE FROM HZ_FINANCIAL_REPORTS
4122: WHERE financial_report_id = l_to;
4123:
4124: DELETE FROM HZ_FINANCIAL_NUMBERS
4125: WHERE financial_report_id = l_to;

Line 4128: UPDATE HZ_FINANCIAL_REPORTS

4124: DELETE FROM HZ_FINANCIAL_NUMBERS
4125: WHERE financial_report_id = l_to;
4126:
4127: /*
4128: UPDATE HZ_FINANCIAL_REPORTS
4129: SET status = 'I',
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,

Line 4151: UPDATE HZ_FINANCIAL_REPORTS

4147: program_update_date = sysdate
4148: WHERE financial_report_id = l_to;
4149: */
4150: ELSE
4151: UPDATE HZ_FINANCIAL_REPORTS
4152: SET status = 'M',
4153: last_update_date = hz_utility_pub.last_update_date,
4154: last_updated_by = hz_utility_pub.user_id,
4155: last_update_login = hz_utility_pub.last_update_login,