DBA Data[Home] [Help]

APPS.HR_GL_COST_CENTERS dependencies on FND_FLEX_VALUE_SETS

Line 393: from fnd_flex_value_sets comp,

389: reptemp.org_name,
390: compname.description,
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,

Line 394: fnd_flex_value_sets cc,

390: compname.description,
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,

Line 494: l_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;

490:
491: type curType is ref cursor;
492: c_list curType;
493:
494: l_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
495:
496: BEGIN
497: p_vs_id := -1;
498: hr_utility.set_location('Entering : '||l_proc,10);

Line 505: , fnd_flex_value_sets vs

501:
502: open c_list for 'select vs.flex_value_set_id,
503: vs.flex_value_set_name
504: from fnd_id_flex_segments_vl seg
505: , fnd_flex_value_sets vs
506: where upper(seg.id_flex_code) = ''GL#''
507: and seg.application_id = 101
508: and seg.flex_value_set_id = vs.flex_value_set_id
509: and seg.enabled_flag = ''Y''