APPS.PQP_GB_OMP_TEMPLATE dependencies on FND_LOOKUP_TYPES_VL

Line 108: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

104: l_abs_ele_correction_pp NUMBER := p_pri_ele_processing_priority - 50;
105: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
106: l_formula_name pay_shadow_formulas.formula_name%TYPE;
107: l_formula_id NUMBER;
108: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
109: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
110: l_abse_days_def VARCHAR2(1);
111: y NUMBER := 0;
112: l_exists VARCHAR2(1);

Line 109: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;

105: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
106: l_formula_name pay_shadow_formulas.formula_name%TYPE;
107: l_formula_id NUMBER;
108: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
109: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
110: l_abse_days_def VARCHAR2(1);
111: y NUMBER := 0;
112: l_exists VARCHAR2(1);
113:

Line 659: FROM fnd_lookup_types_vl

655: --
656:
657: CURSOR csr_chk_uniq_type IS
658: SELECT 'x'
659: FROM fnd_lookup_types_vl
660: WHERE lookup_type = p_lookup_type
661: AND security_group_id = p_security_group_id
662: AND view_application_id = 3;
663:

Line 667: FROM fnd_lookup_types_vl

663:
664: CURSOR csr_chk_uniq_meaning
665: IS
666: SELECT 'x'
667: FROM fnd_lookup_types_vl
668: WHERE meaning = p_lookup_meaning
669: AND security_group_id = p_security_group_id
670: AND view_application_id = 3;
671:

Line 674: l_rowid fnd_lookup_types_vl.row_id%type;

670: AND view_application_id = 3;
671:
672: l_proc_name VARCHAR2(72) := g_proc_name || 'create_lookup';
673: l_exists VARCHAR2(1);
674: l_rowid fnd_lookup_types_vl.row_id%type;
675: l_user_id number := fnd_global.user_id;
676: l_login_id number := fnd_global.login_id;
677:
678: --

Line 807: FROM fnd_lookup_types_vl

803:
804: CURSOR csr_chk_uniq_type
805: IS
806: SELECT 'X'
807: FROM fnd_lookup_types_vl
808: WHERE lookup_type = p_lookup_type
809: AND security_group_id = p_security_group_id
810: AND view_application_id = 3;
811:

Line 815: FROM fnd_lookup_types_vl

811:
812: CURSOR csr_chk_uniq_meaning
813: IS
814: SELECT 'X'
815: FROM fnd_lookup_types_vl
816: WHERE meaning = p_lookup_meaning
817: AND security_group_id = p_security_group_id
818: AND view_application_id = 3;
819:

Line 840: l_rowid fnd_lookup_types_vl.row_id%type;

836: AND view_application_id = 3;
837:
838: l_proc_name VARCHAR2(72) := g_proc_name || 'create_gap_lookup';
839: l_exists VARCHAR2(1);
840: l_rowid fnd_lookup_types_vl.row_id%type;
841: l_user_id number := fnd_global.user_id;
842: l_login_id number := fnd_global.login_id;
843:
844: --

Line 1645: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

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

Line 1797: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

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:
1801: --

Line 1884: FROM fnd_lookup_types_vl

1880: --
1881:
1882: CURSOR csr_get_lkt_info IS
1883: SELECT 'x'
1884: FROM fnd_lookup_types_vl
1885: WHERE lookup_type = p_lookup_type
1886: AND security_group_id = p_security_group_id
1887: AND view_application_id = p_view_application_id;
1888: