APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on PAY_REPORT_DEFINITIONS

Line 105: FROM pay_report_definitions

101: AND legislation_code IS NULL;
102:
103: CURSOR csr_report_definition_id(p_report_group_id NUMBER) IS
104: SELECT report_definition_id
105: FROM pay_report_definitions
106: WHERE report_group_id = p_report_group_id;
107:
108: CURSOR csr_report_cat_comp_id(p_report_category_id IN NUMBER,
109: p_report_definition_id IN NUMBER,

Line 136: ln_report_definition_id pay_report_definitions.report_definition_id%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;
136: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
137: ln_definition_id pay_report_definitions.report_definition_id%TYPE;
138: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;
139: ln_report_variable_id pay_report_variables.report_variable_id%TYPE;
140: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;

Line 137: ln_definition_id pay_report_definitions.report_definition_id%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;
136: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
137: ln_definition_id pay_report_definitions.report_definition_id%TYPE;
138: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;
139: ln_report_variable_id pay_report_variables.report_variable_id%TYPE;
140: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;
141: lv_lookup_type_meaning fnd_common_lookup_types.lookup_type_meaning%TYPE;

Line 346: FROM pay_report_definitions

342: RETURN NUMBER IS
343:
344: CURSOR csr_fetch_definition_id_one IS
345: SELECT report_definition_id
346: FROM pay_report_definitions
347: WHERE report_group_id = pn_report_group_id;
348:
349: CURSOR csr_fetch_definition_id_mul IS
350: SELECT report_definition_id

Line 351: FROM pay_report_definitions

347: WHERE report_group_id = pn_report_group_id;
348:
349: CURSOR csr_fetch_definition_id_mul IS
350: SELECT report_definition_id
351: FROM pay_report_definitions
352: WHERE report_group_id = pn_report_group_id
353: AND upper(report_name) LIKE '%' || upper(substr(pv_template_code,(instr(pv_template_code,'_',-1) + 1),(length(pv_template_code) - instr(pv_template_code,'_',-1)))) || '%';
354: --AND report_type = decode(pv_template_type_code,'ETEXT','EFT',pv_template_type_code);
355:

Line 356: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;

352: WHERE report_group_id = pn_report_group_id
353: AND upper(report_name) LIKE '%' || upper(substr(pv_template_code,(instr(pv_template_code,'_',-1) + 1),(length(pv_template_code) - instr(pv_template_code,'_',-1)))) || '%';
354: --AND report_type = decode(pv_template_type_code,'ETEXT','EFT',pv_template_type_code);
355:
356: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
357: ln_tot_report_definitions NUMBER;
358:
359: BEGIN
360:

Line 362: FROM pay_report_definitions

358:
359: BEGIN
360:
361: SELECT count(*) INTO ln_tot_report_definitions
362: FROM pay_report_definitions
363: WHERE report_group_id = pn_report_group_id;
364:
365: IF ln_tot_report_definitions = 1 THEN
366: OPEN csr_fetch_definition_id_one;