DBA Data[Home] [Help]

APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on HR_ORGANIZATION_INFORMATION

Line 132: lv_legislation_code hr_organization_information.org_information9%TYPE;

128: lv_template_code xdo_templates_tl.template_code%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;

Line 322: lv_legislation_code hr_organization_information.org_information9%TYPE;

318:
319: FUNCTION get_legislation_code(p_business_group_id NUMBER)
320: RETURN VARCHAR2 IS
321:
322: lv_legislation_code hr_organization_information.org_information9%TYPE;
323:
324: BEGIN
325:
326: BEGIN

Line 328: FROM hr_organization_information

324: BEGIN
325:
326: BEGIN
327: SELECT org_information9 INTO lv_legislation_code
328: FROM hr_organization_information
329: WHERE org_information_context = 'Business Group Information'
330: AND organization_id = p_business_group_id;
331: EXCEPTION
332: WHEN OTHERS THEN