APPS.HZ_ORG_INFO_VALIDATE dependencies on HZ_INDUSTRIAL_CLASS_APP

Line 782: FROM HZ_INDUSTRIAL_CLASS_APP

778: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE )) THEN
779: BEGIN
780: SELECT party_id, industrial_class_id, begin_date, end_date
781: INTO l_party_id, l_industrial_class_id, l_begin_date, l_end_date
782: FROM HZ_INDUSTRIAL_CLASS_APP
783: WHERE code_applied_id= p_industrial_class_app_rec.code_applied_id;
784:
785: if l_party_id <> p_industrial_class_app_rec.party_id AND
786: p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM THEN

Line 819: -- industrial_class_id to hz_industrial_class_app

815:
816:
817:
818: -- foreign keys: party_id to HZ_PARTIES table.
819: -- industrial_class_id to hz_industrial_class_app
820:
821: IF p_industrial_class_app_rec.party_id is NOT NULL AND
822: p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM THEN
823: