APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on PAY_REPORT_DEFINITIONS

Line 96: FROM pay_report_definitions

92: AND legislation_code IS NULL;
93:
94: CURSOR csr_report_definition_id(p_report_group_id NUMBER) IS
95: SELECT report_definition_id
96: FROM pay_report_definitions
97: WHERE report_group_id = p_report_group_id;
98:
99: CURSOR csr_report_cat_comp_id(p_report_category_id IN NUMBER,
100: p_report_definition_id IN NUMBER,

Line 127: ln_report_definition_id pay_report_definitions.report_definition_id%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;
127: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
128: ln_definition_id pay_report_definitions.report_definition_id%TYPE;
129: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;
130: ln_report_variable_id pay_report_variables.report_variable_id%TYPE;
131: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;

Line 128: ln_definition_id pay_report_definitions.report_definition_id%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;
127: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
128: ln_definition_id pay_report_definitions.report_definition_id%TYPE;
129: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;
130: ln_report_variable_id pay_report_variables.report_variable_id%TYPE;
131: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;
132: lv_lookup_type_meaning fnd_common_lookup_types.lookup_type_meaning%TYPE;

Line 337: FROM pay_report_definitions

333: RETURN NUMBER IS
334:
335: CURSOR csr_fetch_definition_id_one IS
336: SELECT report_definition_id
337: FROM pay_report_definitions
338: WHERE report_group_id = pn_report_group_id;
339:
340: CURSOR csr_fetch_definition_id_mul IS
341: SELECT report_definition_id

Line 342: FROM pay_report_definitions

338: WHERE report_group_id = pn_report_group_id;
339:
340: CURSOR csr_fetch_definition_id_mul IS
341: SELECT report_definition_id
342: FROM pay_report_definitions
343: WHERE report_group_id = pn_report_group_id
344: 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)))) || '%';
345: --AND report_type = decode(pv_template_type_code,'ETEXT','EFT',pv_template_type_code);
346:

Line 347: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;

343: WHERE report_group_id = pn_report_group_id
344: 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)))) || '%';
345: --AND report_type = decode(pv_template_type_code,'ETEXT','EFT',pv_template_type_code);
346:
347: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
348: ln_tot_report_definitions NUMBER;
349:
350: BEGIN
351:

Line 353: FROM pay_report_definitions

349:
350: BEGIN
351:
352: SELECT count(*) INTO ln_tot_report_definitions
353: FROM pay_report_definitions
354: WHERE report_group_id = pn_report_group_id;
355:
356: IF ln_tot_report_definitions = 1 THEN
357: OPEN csr_fetch_definition_id_one;