APPS.PQH_RBC_UTILITY dependencies on FND_FLEX_VALUE_SETS

Line 414: FROM fnd_flex_value_sets

410: for l_egl_rec in c1 loop
411: if l_egl_rec.col1_value_set_id is not null then
412: SELECT flex_value_set_name
413: into l_flex_value_set_name
414: FROM fnd_flex_value_sets
415: WHERE flex_value_set_id = l_egl_rec.col1_value_set_id;
416: hr_utility.set_location('value set name is'||l_flex_value_set_name,10);
417: else
418: hr_utility.set_location('value set is not used',10);

Line 526: FROM fnd_flex_value_sets

522: for l_egl_rec in c1 loop
523: if l_egl_rec.col1_value_set_id is not null then
524: SELECT flex_value_set_name
525: into l_flex_value_set_name
526: FROM fnd_flex_value_sets
527: WHERE flex_value_set_id = l_egl_rec.col1_value_set_id;
528: hr_utility.set_location('value set name is'||l_flex_value_set_name,10);
529: else
530: hr_utility.set_location('value set is not used',10);

Line 651: from fnd_flex_value_sets

647:
648:
649: cursor csr_fvs(p_valset_name in varchar2) is
650: select flex_value_set_id
651: from fnd_flex_value_sets
652: where flex_value_set_name = p_valset_name;
653: --
654: cursor csr_bec is
655: select eligy_criteria_id

Line 1759: from fnd_flex_value_sets

1755: -- Format type maybe 'C' , 'N' or 'X'
1756: --
1757: Cursor csr_val_type is
1758: Select validation_type, format_type
1759: from fnd_flex_value_sets
1760: Where flex_value_set_id = p_value_set_id;
1761: --
1762: -- The column type may be 'C' , 'V', 'N' , 'D' or null
1763: --

Line 1769: l_validation_type fnd_flex_value_sets.validation_type%type;

1765: select nvl(id_column_type,'O')
1766: from fnd_flex_validation_tables
1767: where flex_value_set_id = p_value_set_id;
1768: --
1769: l_validation_type fnd_flex_value_sets.validation_type%type;
1770: l_format_type fnd_flex_value_sets.format_type%type;
1771: l_col_type fnd_flex_validation_tables.id_column_type%type;
1772: --
1773: Begin

Line 1770: l_format_type fnd_flex_value_sets.format_type%type;

1766: from fnd_flex_validation_tables
1767: where flex_value_set_id = p_value_set_id;
1768: --
1769: l_validation_type fnd_flex_value_sets.validation_type%type;
1770: l_format_type fnd_flex_value_sets.format_type%type;
1771: l_col_type fnd_flex_validation_tables.id_column_type%type;
1772: --
1773: Begin
1774: -- Get the validation type of the valueset