APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on FND_COMMON_LOOKUPS

Line 53: FROM fnd_common_lookups

49: p_business_group_id IN NUMBER) IS
50:
51: CURSOR csr_get_temp_codes(p_lookup_type IN VARCHAR) IS
52: SELECT lookup_code, meaning
53: FROM fnd_common_lookups
54: WHERE lookup_type = p_lookup_type
55: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'PAY')
56: AND sysdate between nvl(start_date_active,sysdate) AND nvl(end_date_active,sysdate)
57: AND enabled_flag = 'Y';

Line 117: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;

113: WHERE report_variable_id = p_report_variable_id
114: AND business_group_id = p_business_group_id
115: AND legislation_code IS NULL;
116:
117: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
118: lv_meaning fnd_common_lookups.meaning%TYPE;
119: lv_template_code xdo_templates_tl.template_code%TYPE;
120: lv_template_name xdo_templates_tl.template_name%TYPE;
121: lv_template_type_code xdo_templates_b.template_type_code%TYPE;

Line 118: lv_meaning fnd_common_lookups.meaning%TYPE;

114: AND business_group_id = p_business_group_id
115: AND legislation_code IS NULL;
116:
117: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
118: lv_meaning fnd_common_lookups.meaning%TYPE;
119: lv_template_code xdo_templates_tl.template_code%TYPE;
120: lv_template_name xdo_templates_tl.template_name%TYPE;
121: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
122: lv_rg_short_name fnd_common_lookups.description%TYPE;

Line 122: lv_rg_short_name fnd_common_lookups.description%TYPE;

118: lv_meaning fnd_common_lookups.meaning%TYPE;
119: lv_template_code xdo_templates_tl.template_code%TYPE;
120: lv_template_name xdo_templates_tl.template_name%TYPE;
121: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
122: lv_rg_short_name fnd_common_lookups.description%TYPE;
123: lv_legislation_code hr_organization_information.org_information9%TYPE;
124: ln_report_group_id pay_report_groups.report_group_id%TYPE;
125: ln_report_category_id pay_report_categories.report_category_id%TYPE;
126: ln_report_category_id_new pay_report_categories.report_category_id%TYPE;

Line 144: FROM fnd_common_lookups

140: fnd_file.put_line(fnd_file.log,'Legislation Code : ' || lv_legislation_code);
141:
142: BEGIN
143: SELECT description INTO lv_rg_short_name
144: FROM fnd_common_lookups
145: WHERE lookup_type = 'GEN_CUST_TEMP_CONC_PROGS'
146: AND lookup_code = p_conc_prog
147: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'PAY')
148: AND sysdate between nvl(start_date_active,sysdate) AND nvl(end_date_active,sysdate)