DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_ORGANIZATION_INDICATORS

Line 590: FROM HZ_ORGANIZATION_INDICATORS

586:
587: CURSOR dupcheck IS
588: SELECT
589: ORGANIZATION_INDICATOR_ID
590: FROM HZ_ORGANIZATION_INDICATORS
591: WHERE party_id = p_to_fk_id
592: AND (status IS NULL OR status = 'A')
593: AND
594: INDICATOR ||

Line 601: FROM HZ_ORGANIZATION_INDICATORS

597: (SELECT
598: INDICATOR ||
599: TO_CHAR(START_DATE, 'DD/MM/YYYY') ||
600: TO_CHAR(END_DATE, 'DD/MM/YYYY')
601: FROM HZ_ORGANIZATION_INDICATORS
602: WHERE organization_indicator_id = p_from_id)
603: AND
604: nvl(DESCRIPTION , 'NODESC') =
605: (SELECT nvl(DESCRIPTION, 'NODESC')

Line 606: FROM HZ_ORGANIZATION_INDICATORS

602: WHERE organization_indicator_id = p_from_id)
603: AND
604: nvl(DESCRIPTION , 'NODESC') =
605: (SELECT nvl(DESCRIPTION, 'NODESC')
606: FROM HZ_ORGANIZATION_INDICATORS
607: WHERE organization_indicator_id = p_from_id);
608:
609: l_record_id NUMBER;
610: BEGIN