APPS.AMW_SCOPE_PVT dependencies on FND_FLEX_VALUES

Line 126: FROM amw_audit_units_v auv,fnd_flex_values flv

122: l_msg_data VARCHAR2(32767);
123:
124: CURSOR find_parent_subsidiary(l_organization_id NUMBER) IS
125: SELECT flv.flex_value_id
126: FROM amw_audit_units_v auv,fnd_flex_values flv
127: WHERE auv.subsidiary_valueset = flv.flex_value_set_id
128: AND auv.company_code = flv.flex_value
129: AND organization_id = l_organization_id;
130:

Line 133: FROM amw_audit_units_v auv,fnd_flex_values flv

129: AND organization_id = l_organization_id;
130:
131: CURSOR find_parent_lob(l_organization_id NUMBER) IS
132: SELECT flv.flex_value_id
133: FROM amw_audit_units_v auv,fnd_flex_values flv
134: WHERE auv.lob_valueset = flv.flex_value_set_id
135: AND auv.lob_code = flv.flex_value
136: AND organization_id = l_organization_id;
137:

Line 147: FROM fnd_flex_values_vl flv, FND_FLEX_VALUE_CHILDREN_V fchild,fnd_flex_values_vl flv2

143: AND organization_id = l_organization_id;
144:
145: CURSOR find_parent_recursive (l_child_id NUMBER) IS
146: SELECT nvl( flv2.flex_value_id, -1) parent_id
147: FROM fnd_flex_values_vl flv, FND_FLEX_VALUE_CHILDREN_V fchild,fnd_flex_values_vl flv2
148: WHERE flv.flex_value = fchild.flex_value (+)
149: AND flv.flex_value_set_id = fchild.flex_value_set_id (+)
150: AND flv2.flex_value(+) = fchild.parent_flex_value
151: AND flv2.flex_value_set_id(+) = fchild.flex_value_set_id

Line 884: FROM amw_audit_units_v auv,fnd_flex_values flv

880: IS
881:
882: l_get_subsidiary_query VARCHAR2(32767) :=
883: 'SELECT DISTINCT flv.flex_value_id
884: FROM amw_audit_units_v auv,fnd_flex_values flv
885: WHERE auv.subsidiary_valueset = flv.flex_value_set_id
886: AND auv.company_code = flv.flex_value';
887:
888:

Line 949: FROM amw_audit_units_v auv,fnd_flex_values flv

945: lobs_cursor lobcurtype;
946:
947: l_get_lob_query VARCHAR2(32767) :=
948: 'SELECT DISTINCT flv.flex_value_id
949: FROM amw_audit_units_v auv,fnd_flex_values flv
950: WHERE auv.lob_valueset = flv.flex_value_set_id
951: AND auv.lob_code = flv.flex_value';
952:
953: l_extra_query VARCHAR2(32767);