DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_SYSTEM_PROPERTIES_V

Line 1003: cz_system_properties_v sys,

999: SELECT NULL INTO v_null
1000: FROM cz_rul_typedpsn_v psn,
1001: cz_conversion_rels_v cnv,
1002: cz_system_property_rels_v rel,
1003: cz_system_properties_v sys,
1004: cz_conversion_rels_v cnv2
1005: WHERE psn.detailed_type_id = cnv.object_type
1006: AND cnv.subject_type = rel.subject_type
1007: AND rel.object_type = sys.rule_id

Line 1047: cz_system_properties_v sys,

1043: SELECT NULL INTO v_null
1044: FROM cz_rul_typedpsn_v psn,
1045: cz_conversion_rels_v cnv,
1046: cz_system_property_rels_v rel,
1047: cz_system_properties_v sys,
1048: cz_conversion_rels_v cnv2
1049: WHERE psn.detailed_type_id = cnv.object_type
1050: AND cnv.subject_type = rel.subject_type
1051: AND rel.object_type = sys.rule_id

Line 5255: FROM cz_system_properties_v

5251: END LOOP;
5252: IF(v_tExprParentId(propChild) = v_tExprId(j))THEN
5253:
5254: SELECT data_type, name INTO DataType, PropName
5255: FROM cz_system_properties_v
5256: WHERE rule_id = v_tExprSubtype(propChild);
5257:
5258: RETURN v_tExprSubtype(propChild);
5259: ELSE