APPS.PQP_GB_OSP_TEMPLATE dependencies on FND_LOOKUP_VALUES_VL

Line 3239: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

3235: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
3236: -- to delete plan types lookup
3237: l_plan_type_lookup fnd_lookup_types_vl.lookup_type%TYPE;
3238:
3239: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
3240: l_exists VARCHAR2(1);
3241: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3242:
3243: TYPE t_number IS TABLE OF NUMBER

Line 3365: FROM fnd_lookup_values_vl

3361:
3362: CURSOR csr_get_lookup_code (c_lookup_type varchar2)
3363: IS
3364: SELECT lookup_code
3365: FROM fnd_lookup_values_vl
3366: WHERE lookup_type = c_lookup_type
3367: AND security_group_id = p_security_group_id
3368: AND view_application_id = 3;
3369:

Line 3414: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

3410: AND pet.business_group_id = p_business_group_id ;
3411:
3412: l_lookup_collection t_number;
3413: l_number NUMBER;
3414: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
3415: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
3416: l_proc_step NUMBER(20,10);
3417: l_proc_name VARCHAR2(72) := g_package_name || 'get_other_lookups';
3418: l_base_name pay_element_templates.base_name%TYPE ;

Line 3515: FROM fnd_lookup_values_vl

3511:
3512: CURSOR csr_get_lkv_info
3513: IS
3514: SELECT lookup_code
3515: FROM fnd_lookup_values_vl
3516: WHERE lookup_type = p_lookup_type
3517: AND security_group_id = p_security_group_id
3518: AND view_application_id = p_view_application_id;
3519:

Line 3523: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

3519:
3520: l_proc_step NUMBER(20,10);
3521: l_proc_name VARCHAR2(72) := g_package_name || 'delete_lookup';
3522: l_exists VARCHAR2(1);
3523: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
3524:
3525: BEGIN
3526: --
3527: debug ('Entering '||l_proc_name, 10);

Line 4143: FROM fnd_lookup_values_vl

4139:
4140: CURSOR csr_chk_uniq_value (c_lookup_code varchar2)
4141: IS
4142: SELECT 'X'
4143: FROM fnd_lookup_values_vl
4144: WHERE lookup_type = p_lookup_type
4145: AND lookup_code = c_lookup_code
4146: AND security_group_id = p_security_group_id
4147: AND view_application_id = 3;

Line 4152: FROM fnd_lookup_values_vl

4148:
4149: CURSOR csr_chk_uniq_value_meaning (c_lookup_meaning varchar2)
4150: IS
4151: SELECT 'X'
4152: FROM fnd_lookup_values_vl
4153: WHERE lookup_type = p_lookup_type
4154: AND meaning = c_lookup_meaning
4155: AND security_group_id = p_security_group_id
4156: AND view_application_id = 3;