APPS.FII_GL_COMCCH_C dependencies on FND_FLEX_VALUES

Line 55: fnd_flex_values com,

51: org.name organization,
52: org.organization_id org_id
53: from FII_COM_CC_MAPPINGS_GT gt,
54: hr_all_organization_units org,
55: fnd_flex_values com,
56: fnd_flex_values cc
57: where gt.company_id = p_com_id
58: and gt.cost_center_id = p_cc_id
59: and gt.company_cost_center_org_id = org.organization_id

Line 56: fnd_flex_values cc

52: org.organization_id org_id
53: from FII_COM_CC_MAPPINGS_GT gt,
54: hr_all_organization_units org,
55: fnd_flex_values com,
56: fnd_flex_values cc
57: where gt.company_id = p_com_id
58: and gt.cost_center_id = p_cc_id
59: and gt.company_cost_center_org_id = org.organization_id
60: and gt.company_id = com.flex_value_id

Line 354: fnd_flex_values flex

350: FROM (SELECT findim.MASTER_VALUE_SET_ID FLEX_VALUE_SET_ID
351: FROM FII_FINANCIAL_DIMENSIONS findim
352: WHERE DIMENSION_SHORT_NAME = 'FII_LOB') vset,
353: fii_lob_assignments lob,
354: fnd_flex_values flex
355: WHERE flex.FLEX_VALUE_SET_ID = vset.FLEX_VALUE_SET_ID
356: AND flex.flex_value = lob.LINE_OF_BUSINESS) x
357: WHERE dim.COMPANY_COST_CENTER_ORG_ID <> -1
358: AND x.b = dim.COMPANY_COST_CENTER_ORG_ID), dim.LOB_ID)

Line 498: fnd_flex_values flex

494: from (SELECT findim.MASTER_VALUE_SET_ID FLEX_VALUE_SET_ID
495: FROM FII_FINANCIAL_DIMENSIONS findim
496: WHERE DIMENSION_SHORT_NAME = 'FII_LOB') vset ,
497: fii_lob_assignments lob ,
498: fnd_flex_values flex
499: where flex.FLEX_VALUE_SET_ID = vset.FLEX_VALUE_SET_ID
500: and flex.flex_value = lob.LINE_OF_BUSINESS) x
501: WHERE dim.COMPANY_COST_CENTER_ORG_ID <> -1
502: AND x.b = dim.COMPANY_COST_CENTER_ORG_ID), dim.LOB_ID)

Line 759: from fnd_flex_values

755:
756: g_phase := 'Find the unassigned LOB ID from this value set: ' || l_vset_id;
757:
758: select flex_value_id into G_UNASSIGNED_LOB_ID
759: from fnd_flex_values
760: where flex_value_set_id = l_vset_id
761: and flex_value = 'UNASSIGNED';
762:
763:

Line 829: fnd_flex_values fv1,

825: Cursor c_all_value_sets is
826: select fv1.flex_value_set_id company_vs_id,
827: fv2.flex_value_set_id cost_center_vs_id
828: from FII_COM_CC_MAPPINGS_GT ccc,
829: fnd_flex_values fv1,
830: fnd_flex_values fv2
831: where ccc.coa_id = -1
832: and ccc.company_id = fv1.flex_value_id
833: and ccc.cost_center_id = fv2.flex_value_id

Line 830: fnd_flex_values fv2

826: select fv1.flex_value_set_id company_vs_id,
827: fv2.flex_value_set_id cost_center_vs_id
828: from FII_COM_CC_MAPPINGS_GT ccc,
829: fnd_flex_values fv1,
830: fnd_flex_values fv2
831: where ccc.coa_id = -1
832: and ccc.company_id = fv1.flex_value_id
833: and ccc.cost_center_id = fv2.flex_value_id
834: for update of ccc.coa_id;

Line 938: fnd_flex_values com,

934: cc.flex_value cost_center,
935: org.name organization
936: from fii_ccc_mgr_gt gt,
937: hr_all_organization_units org,
938: fnd_flex_values com,
939: fnd_flex_values cc
940: where gt.company_id = p_com_id
941: and gt.cost_center_id = p_cc_id
942: and gt.ccc_org_id = org.organization_id

Line 939: fnd_flex_values cc

935: org.name organization
936: from fii_ccc_mgr_gt gt,
937: hr_all_organization_units org,
938: fnd_flex_values com,
939: fnd_flex_values cc
940: where gt.company_id = p_com_id
941: and gt.cost_center_id = p_cc_id
942: and gt.ccc_org_id = org.organization_id
943: and gt.company_id = com.flex_value_id