APPS.PAY_NO_ABS_STATISTICS_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 47: l_legal_employer HR_ORGANIZATION_UNITS.name%type;

43: l_sum NUMBER;
44: l_counter NUMBER := 1;
45: l_payroll_action_id pay_action_information.action_information1%TYPE;
46: l_legal_employer_id number;
47: l_legal_employer HR_ORGANIZATION_UNITS.name%type;
48: l_quater VARCHAR2(3);
49: l_quater_flag VARCHAR2(2):='Y';
50: l_quater_count NUMBER:=0;
51: l_actual_working_days NUMBER;

Line 58: HR_ORGANIZATION_UNITS o,

54: l_effective_date date;
55:
56: CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information5) action_information5
57: from
58: HR_ORGANIZATION_UNITS o,
59: HR_ORGANIZATION_INFORMATION hoi1,
60: pay_action_information pai
61: where pai.action_context_id = l_payroll_action_id
62: and pai.action_information_category ='EMEA REPORT DETAILS'