APPS.HR_GL_COST_CENTERS dependencies on FND_FLEX_VALUES_VL

Line 395: fnd_flex_values_vl compname,

391: ccname.description,
392: reptemp.org_start_date
393: from fnd_flex_value_sets comp,
394: fnd_flex_value_sets cc,
395: fnd_flex_values_vl compname,
396: fnd_flex_values_vl ccname,
397: (select distinct company_value_set,
398: cc_value_set,
399: company,

Line 396: fnd_flex_values_vl ccname,

392: reptemp.org_start_date
393: from fnd_flex_value_sets comp,
394: fnd_flex_value_sets cc,
395: fnd_flex_values_vl compname,
396: fnd_flex_values_vl ccname,
397: (select distinct company_value_set,
398: cc_value_set,
399: company,
400: cost_center,

Line 721: from fnd_flex_values_vl

717:
718: /* First derive the organization name....
719: */
720: open c_list for 'select description ,start_date_active
721: from fnd_flex_values_vl
722: where flex_value_set_id = :1
723: and flex_value = :2 '
724: using p_company_vs, p_company;
725: fetch c_list into l_company_desc,l_comp_start_dt;

Line 734: from fnd_flex_values_vl

730: l_company_desc := p_company;
731: end if;
732:
733: open c_list for 'select description ,start_date_active
734: from fnd_flex_values_vl
735: where flex_value_set_id = :1
736: and flex_value = :2'
737: using p_cc_vs, p_cost_center;
738: fetch c_list into l_cc_desc,l_cc_start_dt;

Line 1448: from fnd_flex_values_vl

1444: -----
1445:
1446: cursor c_value(p_vs number, p_segment varchar2) is
1447: select description, start_date_active
1448: from fnd_flex_values_vl
1449: where flex_value_set_id= p_vs
1450: and p_segment = flex_value;
1451:
1452: ----