APPS.PAY_DK_PR_ELE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 509: FROM hr_all_organization_units haou

505:
506: --to fetch the organization name
507: BEGIN
508: SELECT haou.name INTO l_business_group_name
509: FROM hr_all_organization_units haou
510: WHERE haou.organization_id=l_business_group_id;
511: EXCEPTION
512: WHEN OTHERS THEN
513: NULL;

Line 682: l_employer hr_all_organization_units.name%type;

678: (p_payroll_action_id in VARCHAR2 ,
679: p_template_name in VARCHAR2 ,
680: p_xml OUT NOCOPY CLOB )
681: IS
682: l_employer hr_all_organization_units.name%type;
683: l_orgnumber hr_organization_information.org_information1%type;
684: l_from_date DATE;
685: l_to_date DATE;
686: -- For bug fix 5231458