APPS.PQP_GB_UNPAID_TEMPLATE dependencies on FND_LOOKUP_VALUES_VL

Line 1603: FROM fnd_lookup_values_vl

1599:
1600: CURSOR csr_get_lookup_code (c_lookup_type varchar2)
1601: IS
1602: SELECT lookup_code
1603: FROM fnd_lookup_values_vl
1604: WHERE lookup_type = c_lookup_type
1605: AND security_group_id = p_security_group_id
1606: AND view_application_id = 3;
1607:

Line 1611: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

1607:
1608:
1609: l_lookup_collection t_number;
1610: l_number NUMBER;
1611: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1612: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1613: l_proc_step NUMBER(20,10);
1614: l_proc_name VARCHAR2(72) := g_package_name || 'get_other_lookups';
1615: l_base_name pay_element_templates.base_name%TYPE ;

Line 1709: FROM fnd_lookup_values_vl

1705:
1706: CURSOR csr_get_lkv_info
1707: IS
1708: SELECT lookup_code
1709: FROM fnd_lookup_values_vl
1710: WHERE lookup_type = p_lookup_type
1711: AND security_group_id = p_security_group_id
1712: AND view_application_id = p_view_application_id;
1713:

Line 1717: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

1713:
1714: l_proc_step NUMBER(20,10);
1715: l_proc_name VARCHAR2(72) := g_package_name || 'delete_lookup';
1716: l_exists VARCHAR2(1);
1717: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1718:
1719: BEGIN
1720: --
1721: debug ('Entering '||l_proc_name, 10);

Line 1958: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

1954: l_ovn_eei number;
1955: l_entudt_id pay_user_tables.user_table_id%TYPE;
1956: l_caludt_id pay_user_tables.user_table_id%TYPE;
1957: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1958: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1959: l_exists VARCHAR2(1);
1960: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1961:
1962: l_lookup_collection t_number;

Line 2078: FROM fnd_lookup_values_vl

2074:
2075: CURSOR csr_get_lookup_code (c_lookup_type varchar2)
2076: IS
2077: SELECT lookup_code
2078: FROM fnd_lookup_values_vl
2079: WHERE lookup_type = c_lookup_type
2080: AND security_group_id = p_security_group_id
2081: AND view_application_id = 3;
2082: