APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on FND_COMMON_LOOKUPS

Line 62: FROM fnd_common_lookups

58: p_business_group_id IN NUMBER) IS
59:
60: CURSOR csr_get_temp_codes(p_lookup_type IN VARCHAR) IS
61: SELECT lookup_code, meaning
62: FROM fnd_common_lookups
63: WHERE lookup_type = p_lookup_type
64: AND application_id IN (800,801)
65: AND sysdate between nvl(start_date_active,sysdate) AND nvl(end_date_active,sysdate)
66: AND enabled_flag = 'Y';

Line 126: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;

122: WHERE report_variable_id = p_report_variable_id
123: AND business_group_id = p_business_group_id
124: AND legislation_code IS NULL;
125:
126: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
127: lv_meaning fnd_common_lookups.meaning%TYPE;
128: lv_template_code xdo_templates_tl.template_code%TYPE;
129: lv_template_name xdo_templates_tl.template_name%TYPE;
130: lv_template_type_code xdo_templates_b.template_type_code%TYPE;

Line 127: lv_meaning fnd_common_lookups.meaning%TYPE;

123: AND business_group_id = p_business_group_id
124: AND legislation_code IS NULL;
125:
126: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
127: lv_meaning fnd_common_lookups.meaning%TYPE;
128: lv_template_code xdo_templates_tl.template_code%TYPE;
129: lv_template_name xdo_templates_tl.template_name%TYPE;
130: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
131: lv_rg_short_name fnd_common_lookups.description%TYPE;

Line 131: lv_rg_short_name fnd_common_lookups.description%TYPE;

127: lv_meaning fnd_common_lookups.meaning%TYPE;
128: lv_template_code xdo_templates_tl.template_code%TYPE;
129: lv_template_name xdo_templates_tl.template_name%TYPE;
130: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
131: lv_rg_short_name fnd_common_lookups.description%TYPE;
132: lv_legislation_code hr_organization_information.org_information9%TYPE;
133: ln_report_group_id pay_report_groups.report_group_id%TYPE;
134: ln_report_category_id pay_report_categories.report_category_id%TYPE;
135: ln_report_category_id_new pay_report_categories.report_category_id%TYPE;

Line 153: FROM fnd_common_lookups

149: fnd_file.put_line(fnd_file.log,'Legislation Code : ' || lv_legislation_code);
150:
151: BEGIN
152: SELECT description INTO lv_rg_short_name
153: FROM fnd_common_lookups
154: WHERE lookup_type = 'GEN_CUST_TEMP_CONC_PROGS'
155: AND lookup_code = p_conc_prog
156: AND application_id IN (800, 801) /* Bug 8716056 */
157: AND SYSDATE between nvl(start_date_active,sysdate) AND nvl(end_date_active,sysdate)