APPS.PAY_NO_HOLIDAY_ENT_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 44: l_legal_employer HR_ORGANIZATION_UNITS.name%type;

40: l_sum NUMBER;
41: l_counter NUMBER := 1;
42: l_payroll_action_id pay_action_information.action_information1%TYPE;
43: l_legal_employer_id number;
44: l_legal_employer HR_ORGANIZATION_UNITS.name%type;
45: l_eff_date date;
46: CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information4) from
47: HR_ORGANIZATION_UNITS o,
48: HR_ORGANIZATION_INFORMATION hoi1,

Line 47: HR_ORGANIZATION_UNITS o,

43: l_legal_employer_id number;
44: l_legal_employer HR_ORGANIZATION_UNITS.name%type;
45: l_eff_date date;
46: CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information4) from
47: HR_ORGANIZATION_UNITS o,
48: HR_ORGANIZATION_INFORMATION hoi1,
49: pay_action_information pai
50: where pai.action_context_id = l_payroll_action_id
51: and pai.action_information_category ='EMEA REPORT DETAILS'