APPS.PQP_GB_OMP_TEMPLATE dependencies on FND_LOOKUP_VALUES_VL

Line 823: FROM fnd_lookup_values_vl

819:
820: CURSOR csr_chk_uniq_value (c_lookup_code varchar2)
821: IS
822: SELECT 'X'
823: FROM fnd_lookup_values_vl
824: WHERE lookup_type = p_lookup_type
825: AND lookup_code = c_lookup_code
826: AND security_group_id = p_security_group_id
827: AND view_application_id = 3;

Line 832: FROM fnd_lookup_values_vl

828:
829: CURSOR csr_chk_uniq_value_meaning (c_lookup_meaning varchar2)
830: IS
831: SELECT 'X'
832: FROM fnd_lookup_values_vl
833: WHERE lookup_type = p_lookup_type
834: AND meaning = c_lookup_meaning
835: AND security_group_id = p_security_group_id
836: AND view_application_id = 3;

Line 1646: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

1642: l_ovn_eei number;
1643: l_entudt_id pay_user_tables.user_table_id%TYPE;
1644: l_caludt_id pay_user_tables.user_table_id%TYPE;
1645: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1646: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1647: l_exists VARCHAR2(1);
1648: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1649:
1650: TYPE t_number IS TABLE OF NUMBER

Line 1748: FROM fnd_lookup_values_vl

1744:
1745: CURSOR csr_get_lookup_code (c_lookup_type varchar2)
1746: IS
1747: SELECT lookup_code
1748: FROM fnd_lookup_values_vl
1749: WHERE lookup_type = c_lookup_type
1750: AND security_group_id = p_security_group_id
1751: AND view_application_id = 3;
1752:

Line 1796: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

1792: AND pet.business_group_id = p_business_group_id ;
1793:
1794: l_lookup_collection t_number;
1795: l_number NUMBER;
1796: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1797: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1798: l_proc_name VARCHAR2(72) := g_proc_name || 'get_other_lookups';
1799: l_base_name pay_element_templates.base_name%TYPE ;
1800:

Line 1891: FROM fnd_lookup_values_vl

1887: AND view_application_id = p_view_application_id;
1888:
1889: CURSOR csr_get_lkv_info IS
1890: SELECT lookup_code
1891: FROM fnd_lookup_values_vl
1892: WHERE lookup_type = p_lookup_type
1893: AND security_group_id = p_security_group_id
1894: AND view_application_id = p_view_application_id;
1895:

Line 1898: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

1894: AND view_application_id = p_view_application_id;
1895:
1896: l_proc_name VARCHAR2(72) := g_proc_name || 'delete_lookup';
1897: l_exists VARCHAR2(1);
1898: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1899:
1900: BEGIN
1901: --
1902: hr_utility.set_location ('Entering '||l_proc_name, 10);