DBA Data[Home] [Help]

APPS.AMW_LOAD_CTRL_DATA dependencies on AMW_LOOKUPS

Line 734: FROM AMW_LOOKUPS

730: PROCEDURE control_components (p_ctrl_comp_flag IN VARCHAR2, p_lookup_tag IN VARCHAR2)
731: IS
732: CURSOR c_control_comp IS
733: SELECT lookup_code
734: FROM AMW_LOOKUPS
735: WHERE lookup_type='AMW_ASSESSMENT_COMPONENTS'
736: AND enabled_flag='Y'
737: AND tag=p_lookup_tag;
738:

Line 872: FROM AMW_LOOKUPS

868: PROCEDURE control_objectives (p_ctrl_obj_flag IN VARCHAR2, p_lookup_tag IN VARCHAR2)
869: IS
870: CURSOR c_control_obj IS
871: SELECT lookup_code
872: FROM AMW_LOOKUPS
873: WHERE lookup_type='AMW_CONTROL_OBJECTIVES'
874: AND enabled_flag='Y'
875: AND tag=p_lookup_tag;
876:

Line 1007: FROM AMW_LOOKUPS

1003: PROCEDURE control_assertions (p_ctrl_assert_flag IN VARCHAR2, p_lookup_tag IN VARCHAR2)
1004: IS
1005: CURSOR c_control_assert IS
1006: SELECT lookup_code
1007: FROM AMW_LOOKUPS
1008: WHERE lookup_type='AMW_CONTROL_ASSERTIONS'
1009: AND enabled_flag='Y'
1010: AND tag=p_lookup_tag;
1011:

Line 1150: FROM AMW_LOOKUPS

1146: PROCEDURE control_PURPOSES (p_ctrl_PURPOSE_flag IN VARCHAR2, p_lookup_tag IN VARCHAR2)
1147: IS
1148: CURSOR c_control_PURPOSE IS
1149: SELECT lookup_code
1150: FROM AMW_LOOKUPS
1151: WHERE lookup_type='AMW_CONTROL_PURPOSES'
1152: AND enabled_flag='Y'
1153: AND tag=p_lookup_tag;
1154: