APPS.PQP_GB_UNPAID_TEMPLATE dependencies on FND_LOOKUP_TYPES_VL

Line 629: FROM fnd_lookup_types_vl

625:
626: CURSOR csr_chk_uniq_type
627: IS
628: SELECT 'X'
629: FROM fnd_lookup_types_vl
630: WHERE lookup_type = p_lookup_type
631: AND security_group_id = p_security_group_id
632: AND view_application_id = 3;
633:

Line 637: FROM fnd_lookup_types_vl

633:
634: CURSOR csr_chk_uniq_meaning
635: IS
636: SELECT 'X'
637: FROM fnd_lookup_types_vl
638: WHERE meaning = p_lookup_meaning
639: AND security_group_id = p_security_group_id
640: AND view_application_id = 3;
641:

Line 645: l_rowid fnd_lookup_types_vl.row_id%type;

641:
642: l_proc_step NUMBER(20,10);
643: l_proc_name VARCHAR2(72) := g_package_name || 'create_lookup';
644: l_exists VARCHAR2(1);
645: l_rowid fnd_lookup_types_vl.row_id%type;
646: l_user_id number := fnd_global.user_id;
647: l_login_id number := fnd_global.login_id;
648: i number ;
649:

Line 883: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

879: l_abs_ele_correction_pp NUMBER := p_abs_ele_processing_priority - 50;
880: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
881: l_formula_name pay_shadow_formulas.formula_name%TYPE;
882: l_formula_id ff_formulas_f.formula_id%TYPE ;
883: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
884: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
885: l_exists VARCHAR2(1);
886: l_display_sequence NUMBER;
887: l_base_name pay_element_templates.base_name%TYPE

Line 884: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;

880: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
881: l_formula_name pay_shadow_formulas.formula_name%TYPE;
882: l_formula_id ff_formulas_f.formula_id%TYPE ;
883: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
884: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
885: l_exists VARCHAR2(1);
886: l_display_sequence NUMBER;
887: l_base_name pay_element_templates.base_name%TYPE
888: := UPPER(TRANSLATE(TRIM(p_abs_ele_name),' ','_'));

Line 1612: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

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 ;
1616:

Line 1701: FROM fnd_lookup_types_vl

1697:
1698: CURSOR csr_get_lkt_info
1699: IS
1700: SELECT 'X'
1701: FROM fnd_lookup_types_vl
1702: WHERE lookup_type = p_lookup_type
1703: AND security_group_id = p_security_group_id
1704: AND view_application_id = p_view_application_id;
1705:

Line 1957: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

1953: l_eei_info_id number;
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: