APPS.PAY_MX_SUBSIDY_EMP_PD_RPT dependencies on HR_ORGANIZATION_UNITS

Line 749: FROM hr_organization_units hou

745: PROCEDURE generate_xml_header AS
746:
747: CURSOR c_le_name IS
748: SELECT hou.name
749: FROM hr_organization_units hou
750: WHERE hou.organization_id = gn_legal_er_id;
751:
752: l_proc_name varchar2(100);
753: lv_buf varchar2(2000);

Line 755: lv_le_name hr_organization_units.name%type;

751:
752: l_proc_name varchar2(100);
753: lv_buf varchar2(2000);
754: lv_rpt_sort_opt VARCHAR2(100);
755: lv_le_name hr_organization_units.name%type;
756: ln_payroll_action_id NUMBER;
757: BEGIN
758: l_proc_name := g_proc_name || 'GENERATE_XML_HEADER';
759: hr_utility_trace ('Entering '||l_proc_name);