APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_FINANCIAL_REPORTS

Line 482: FROM HZ_FINANCIAL_REPORTS

478:
479: CURSOR dupcheck (source_type VARCHAR2) IS
480: SELECT
481: FINANCIAL_REPORT_ID
482: FROM HZ_FINANCIAL_REPORTS
483: WHERE party_id = p_to_fk_id
484: AND
485: TO_CHAR(DATE_REPORT_ISSUED, 'DD/MM/YYYY') ||
486: DOCUMENT_REFERENCE ||

Line 500: FROM HZ_FINANCIAL_REPORTS

496: TYPE_OF_FINANCIAL_REPORT ||
497: TO_CHAR(REPORT_START_DATE, 'DD/MM/YYYY') ||
498: TO_CHAR(REPORT_END_DATE, 'DD/MM/YYYY') ||
499: DECODE (source_type,'P',actual_content_source,'S')
500: FROM HZ_FINANCIAL_REPORTS
501: WHERE financial_report_id = p_from_id);
502:
503: CURSOR c_cont_source IS
504: SELECT ACTUAL_CONTENT_SOURCE

Line 505: FROM HZ_FINANCIAL_REPORTS

501: WHERE financial_report_id = p_from_id);
502:
503: CURSOR c_cont_source IS
504: SELECT ACTUAL_CONTENT_SOURCE
505: FROM HZ_FINANCIAL_REPORTS
506: WHERE financial_report_id = p_from_id;
507:
508: CURSOR dnb_dup_check IS --5396227
509: SELECT financial_report_id

Line 510: FROM HZ_FINANCIAL_REPORTS

506: WHERE financial_report_id = p_from_id;
507:
508: CURSOR dnb_dup_check IS --5396227
509: SELECT financial_report_id
510: FROM HZ_FINANCIAL_REPORTS
511: WHERE party_id = p_to_fk_id
512: AND actual_content_source = 'DNB'
513: AND nvl(status, 'A') = 'A'
514: AND type_of_financial_report= (SELECT type_of_financial_report

Line 515: FROM HZ_FINANCIAL_REPORTS

511: WHERE party_id = p_to_fk_id
512: AND actual_content_source = 'DNB'
513: AND nvl(status, 'A') = 'A'
514: AND type_of_financial_report= (SELECT type_of_financial_report
515: FROM HZ_FINANCIAL_REPORTS
516: WHERE financial_report_id = p_from_id);
517:
518: l_cont_source VARCHAR2(255);
519: l_cont_source_type VARCHAR2(255);