APPS.AMW_ORG_CERT_AGGR_PKG dependencies on FND_FLEX_VALUE_CHILDREN_V

Line 40: fnd_flex_value_children_v fchild,

36: -- Get the parent_id and insert a row in the table if appropriate
37: SELECT nvl(flv2.flex_value_id, -1) parent_id
38: INTO l_parent_id
39: FROM fnd_flex_values flv,
40: fnd_flex_value_children_v fchild,
41: fnd_flex_values flv2
42: WHERE fchild.flex_value (+)= flv.flex_value
43: AND fchild.flex_value_set_id (+)= flv.flex_value_set_id
44: AND flv2.flex_value (+)= fchild.parent_flex_value

Line 124: fnd_flex_value_children_v fchild,

120: TOP_ORG_PROC_PENDING_CERT,
121: SUB_ORG_CERT_ISSUES,
122: PROC_CERT_ISSUES
123: FROM fnd_flex_values flv,
124: fnd_flex_value_children_v fchild,
125: fnd_flex_values flv_c,
126: amw_org_cert_aggr_sum ocas
127: WHERE flv.flex_value_id = p_subsidiary_id
128: AND fchild.flex_value_set_id = flv.flex_value_set_id

Line 283: fnd_flex_value_children_v fchild,

279: -- Get the parent_id and recurse up the hierarchy
280: SELECT nvl(flv2.flex_value_id, -1) parent_id
281: INTO l_parent_id
282: FROM fnd_flex_values flv,
283: fnd_flex_value_children_v fchild,
284: fnd_flex_values flv2
285: WHERE fchild.flex_value (+)= flv.flex_value
286: AND fchild.flex_value_set_id (+)= flv.flex_value_set_id
287: AND flv2.flex_value (+)= fchild.parent_flex_value