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 1755: from fnd_flex_value_sets

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

Line 1765: l_validation_type fnd_flex_value_sets.validation_type%type;

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

Line 1766: l_format_type fnd_flex_value_sets.format_type%type;

1762: from fnd_flex_validation_tables
1763: where flex_value_set_id = p_value_set_id;
1764: --
1765: l_validation_type fnd_flex_value_sets.validation_type%type;
1766: l_format_type fnd_flex_value_sets.format_type%type;
1767: l_col_type fnd_flex_validation_tables.id_column_type%type;
1768: --
1769: Begin
1770: -- Get the validation type of the valueset