DBA Data[Home] [Help]

APPS.CZ_RULES_SEQ dependencies on CZ_RULE_FOLDERS

Line 751: FOR k IN ( SELECT a.* FROM CZ_RULES a, CZ_RULE_FOLDERS b

747: SET effective_from=p_new_start_date,
748: effective_until=p_new_end_date
749: WHERE effectivity_set_id=p_effectivity_set_id RETURNING name INTO var_eff_name;
750:
751: FOR k IN ( SELECT a.* FROM CZ_RULES a, CZ_RULE_FOLDERS b
752: WHERE a.rule_folder_id = b.rule_folder_id
753: AND b.folder_type=1 AND b.deleted_flag=NO_FLAG
754: AND a.effectivity_set_id=p_effectivity_set_id
755: AND a.deleted_flag=NO_FLAG)