DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_SYSTEM_PROPERTIES_V

Line 1014: cz_system_properties_v sys,

1010: SELECT NULL INTO v_null
1011: FROM cz_rul_typedpsn_v psn,
1012: cz_conversion_rels_v cnv,
1013: cz_system_property_rels_v rel,
1014: cz_system_properties_v sys,
1015: cz_conversion_rels_v cnv2
1016: WHERE psn.detailed_type_id = cnv.object_type
1017: AND cnv.subject_type = rel.subject_type
1018: AND rel.object_type = sys.rule_id

Line 1058: cz_system_properties_v sys,

1054: SELECT NULL INTO v_null
1055: FROM cz_rul_typedpsn_v psn,
1056: cz_conversion_rels_v cnv,
1057: cz_system_property_rels_v rel,
1058: cz_system_properties_v sys,
1059: cz_conversion_rels_v cnv2
1060: WHERE psn.detailed_type_id = cnv.object_type
1061: AND cnv.subject_type = rel.subject_type
1062: AND rel.object_type = sys.rule_id

Line 5266: FROM cz_system_properties_v

5262: END LOOP;
5263: IF(v_tExprParentId(propChild) = v_tExprId(j))THEN
5264:
5265: SELECT data_type, name INTO DataType, PropName
5266: FROM cz_system_properties_v
5267: WHERE rule_id = v_tExprSubtype(propChild);
5268:
5269: RETURN v_tExprSubtype(propChild);
5270: ELSE