APPS.ZX_FC_MIGRATE_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 3600: HZ_CODE_ASSIGNMENTS

3596: WHERE CLASS_CATEGORY = 'VENDOR TYPE'
3597: AND CONCAT_CLASS_CODE = 'EMPLOYEE');
3598:
3599: INSERT ALL INTO
3600: HZ_CODE_ASSIGNMENTS
3601: (CODE_ASSIGNMENT_ID,
3602: OWNER_TABLE_NAME,
3603: OWNER_TABLE_ID,
3604: CLASS_CATEGORY,

Line 3629: VALUES( HZ_CODE_ASSIGNMENTS_S.nextval,

3625: OWNER_TABLE_KEY_4,
3626: OWNER_TABLE_KEY_5,
3627: PROGRAM_APPLICATION_ID,
3628: PROGRAM_ID)
3629: VALUES( HZ_CODE_ASSIGNMENTS_S.nextval,
3630: 'ZX_PARTY_TAX_PROFILE',
3631: party_tax_profile_id,
3632: 'VENDOR TYPE',
3633: fiscal_classification_code,

Line 3666: AND NOT EXISTS(SELECT 1 FROM HZ_CODE_ASSIGNMENTS

3662: WHERE POV.PARTY_ID = PTP.PARTY_ID
3663: AND PTP.PARTY_TYPE_CODE = 'THIRD_PARTY'
3664: AND POV.VENDOR_TYPE_LOOKUP_CODE IS NOT NULL
3665: AND POV.Employee_ID IS NOT NULL
3666: AND NOT EXISTS(SELECT 1 FROM HZ_CODE_ASSIGNMENTS
3667: WHERE CLASS_CATEGORY = 'VENDOR TYPE'
3668: AND CLASS_CODE = POV.VENDOR_TYPE_LOOKUP_CODE
3669: AND OWNER_TABLE_ID = PARTY_TAX_PROFILE_ID)
3670: GROUP BY PTP.PARTY_TAX_PROFILE_ID,POV.VENDOR_TYPE_LOOKUP_CODE;