eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on HR_ORGANIZATION_INFORMATION

Line 123: lv_legislation_code hr_organization_information.org_information9%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;
127: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;

Line 313: lv_legislation_code hr_organization_information.org_information9%TYPE;

309:
310: FUNCTION get_legislation_code(p_business_group_id NUMBER)
311: RETURN VARCHAR2 IS
312:
313: lv_legislation_code hr_organization_information.org_information9%TYPE;
314:
315: BEGIN
316:
317: BEGIN

Line 319: FROM hr_organization_information

315: BEGIN
316:
317: BEGIN
318: SELECT org_information9 INTO lv_legislation_code
319: FROM hr_organization_information
320: WHERE org_information_context = 'Business Group Information'
321: AND organization_id = p_business_group_id;
322: EXCEPTION
323: WHEN OTHERS THEN