APPS.HZ_RELATIONSHIP_TYPE_V2PUB dependencies on FND_OBJECT_INSTANCE_SETS

Line 880: l_predicate FND_OBJECT_INSTANCE_SETS.predicate%TYPE;

876: l_column_name VARCHAR2(80);
877: -- l_predicate VARCHAR2(80);
878: --Bug fix 2700936
879:
880: l_predicate FND_OBJECT_INSTANCE_SETS.predicate%TYPE;
881: l_str VARCHAR2(5000);
882: rows NUMBER;
883: c NUMBER;
884: result VARCHAR2(1) := 'N';

Line 892: FND_OBJECT_INSTANCE_SETS FOIS

888: SELECT OBJ_NAME,
889: PK1_COLUMN_NAME,
890: PREDICATE
891: FROM FND_OBJECTS FO,
892: FND_OBJECT_INSTANCE_SETS FOIS
893: WHERE FOIS.INSTANCE_SET_NAME = p_instance_set_name
894: AND FOIS.OBJECT_ID = FO.OBJECT_ID;
895:
896: CURSOR c_parties(p_party_id IN NUMBER, p_party_type IN VARCHAR2)