APPS.HZ_PARTY_MERGE dependencies on HZ_FINANCIAL_REPORTS

Line 4491: -- Handle DNB data in HZ_FINANCIAL_REPORTS

4487: END;
4488: END LOOP;
4489:
4490: -- *******************************************
4491: -- Handle DNB data in HZ_FINANCIAL_REPORTS
4492: FOR FROM_FR IN (
4493: SELECT financial_report_id,
4494: type_of_financial_report,
4495: TO_CHAR(DATE_REPORT_ISSUED, 'DD/MM/YYYY') ||

Line 4501: FROM HZ_FINANCIAL_REPORTS

4497: ISSUED_PERIOD ||
4498: TO_CHAR(REPORT_START_DATE, 'DD/MM/YYYY') ||
4499: TO_CHAR(REPORT_END_DATE, 'DD/MM/YYYY') ||
4500: actual_content_source con_cat --for bug 6600935
4501: FROM HZ_FINANCIAL_REPORTS
4502: WHERE actual_content_source = 'DNB'
4503: AND nvl(status, 'A') = 'A'
4504: AND party_id = p_from_id) LOOP
4505:

Line 4508: FROM HZ_FINANCIAL_REPORTS

4504: AND party_id = p_from_id) LOOP
4505:
4506: BEGIN
4507: SELECT financial_report_id INTO l_to
4508: FROM HZ_FINANCIAL_REPORTS
4509: WHERE actual_content_source = 'DNB'
4510: AND nvl(status, 'A') = 'A'
4511: AND type_of_financial_report=FROM_FR.type_of_financial_report
4512: AND TO_CHAR(DATE_REPORT_ISSUED, 'DD/MM/YYYY') ||

Line 4523: DELETE FROM HZ_FINANCIAL_REPORTS

4519:
4520: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
4521:
4522: /*Bug 3236556*/
4523: DELETE FROM HZ_FINANCIAL_REPORTS
4524: WHERE financial_report_id = l_to;
4525:
4526: DELETE FROM HZ_FINANCIAL_NUMBERS
4527: WHERE financial_report_id = l_to;

Line 4530: UPDATE HZ_FINANCIAL_REPORTS

4526: DELETE FROM HZ_FINANCIAL_NUMBERS
4527: WHERE financial_report_id = l_to;
4528:
4529: /*
4530: UPDATE HZ_FINANCIAL_REPORTS
4531: SET status = 'I',
4532: last_update_date = hz_utility_pub.last_update_date,
4533: last_updated_by = hz_utility_pub.user_id,
4534: last_update_login = hz_utility_pub.last_update_login,

Line 4553: UPDATE HZ_FINANCIAL_REPORTS

4549: program_update_date = sysdate
4550: WHERE financial_report_id = l_to;
4551: */
4552: ELSE
4553: UPDATE HZ_FINANCIAL_REPORTS
4554: SET status = 'M',
4555: last_update_date = hz_utility_pub.last_update_date,
4556: last_updated_by = hz_utility_pub.user_id,
4557: last_update_login = hz_utility_pub.last_update_login,