APPS.CZ_PSFT_INTEGRATION_PVT dependencies on CZ_PS_NODES

Line 861: FROM cz_ps_nodes psn, cz_item_masters itm

857: l_type INTEGER;
858: BEGIN
859: FOR i IN (SELECT devl_project_id, ps_node_id, persistent_node_id, ps_node_type,
860: reference_id, feature_type, minimum, maximum, itm.orig_sys_ref osr
861: FROM cz_ps_nodes psn, cz_item_masters itm
862: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
863: (SELECT component_id FROM cz_model_ref_expls
864: WHERE deleted_flag = '0' AND model_id = p_model_id
865: AND (model_id = component_id OR ps_node_type = PS_NODE_TYPE_REFERENCE))

Line 904: FROM cz_ps_nodes psn, cz_ps_prop_vals psp, cz_properties prp

900: BEGIN
901: FOR i IN (SELECT prp.property_id id, prp.name name, prp.data_type type, prp.def_value defval,
902: psp.data_value strval, prp.def_num_value defnumval, psp.data_num_value numval,
903: psn.devl_project_id project, psn.persistent_node_id persistentid
904: FROM cz_ps_nodes psn, cz_ps_prop_vals psp, cz_properties prp
905: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
906: (SELECT component_id FROM cz_model_ref_expls
907: WHERE deleted_flag = '0' AND model_id = p_model_id
908: AND (model_id = component_id OR ps_node_type = PS_NODE_TYPE_REFERENCE))

Line 916: FROM cz_ps_nodes psn, cz_ps_prop_vals psp, cz_properties prp,

912: UNION ALL
913: SELECT prp.property_id id, prp.name name, prp.data_type type, deftxt.text_str defval,
914: txt.text_str strval, prp.def_num_value defnumval, psp.data_num_value numval,
915: psn.devl_project_id project, psn.persistent_node_id persistentid
916: FROM cz_ps_nodes psn, cz_ps_prop_vals psp, cz_properties prp,
917: cz_intl_texts deftxt, cz_intl_texts txt
918: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
919: (SELECT component_id FROM cz_model_ref_expls
920: WHERE deleted_flag = '0' AND model_id = p_model_id