DBA Data[Home] [Help]

APPS.CZ_PS_COPY dependencies on CZ_PS_PROP_VALS

Line 519: FROM CZ_PS_PROP_VALS

515:
516: BEGIN
517: -- sselahi
518: FOR i IN (SELECT ps_node_id,property_id,data_value,data_num_value
519: FROM CZ_PS_PROP_VALS
520: WHERE ps_node_id=p_old_ps_id AND deleted_flag='0')
521: LOOP
522: INSERT INTO CZ_PS_PROP_VALS
523: (PS_NODE_ID,

Line 522: INSERT INTO CZ_PS_PROP_VALS

518: FOR i IN (SELECT ps_node_id,property_id,data_value,data_num_value
519: FROM CZ_PS_PROP_VALS
520: WHERE ps_node_id=p_old_ps_id AND deleted_flag='0')
521: LOOP
522: INSERT INTO CZ_PS_PROP_VALS
523: (PS_NODE_ID,
524: PROPERTY_ID,
525: DATA_VALUE,
526: DATA_NUM_VALUE, -- sselahi

Line 537: FROM CZ_PS_PROP_VALS

533: DATA_NUM_VALUE, -- sselahi
534: DELETED_FLAG,
535: SECURITY_MASK,
536: CHECKOUT_USER
537: FROM CZ_PS_PROP_VALS
538: WHERE PS_NODE_ID=p_old_ps_id AND property_id=i.property_id
539: AND data_value=i.data_value AND data_num_value=i.data_num_value AND deleted_flag=NO_FLAG;
540:
541: PACK;