APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on PAY_REPORT_GROUPS

Line 86: FROM pay_report_groups

82:
83: CURSOR csr_report_group_id(p_report_group_short_name IN VARCHAR,
84: p_legislation_code IN VARCHAR) IS
85: SELECT report_group_id
86: FROM pay_report_groups
87: WHERE short_name = p_report_group_short_name
88: AND business_group_id IS NULL
89: /*AND nvl(legislation_code,'US') = nvl(p_legislation_code,'US');*/
90: AND ((legislation_code = p_legislation_code) OR (legislation_code IS NULL));

Line 133: ln_report_group_id pay_report_groups.report_group_id%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;
136: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
137: ln_definition_id pay_report_definitions.report_definition_id%TYPE;