APPS.PAY_FR_TERMINATION_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 101: hr_organization_information

97: select to_number(org_information3) monthly_hours,
98: fnd_date.canonical_to_date(org_information1) date_from,
99: fnd_date.canonical_to_date(org_information2) date_to
100: from
101: hr_organization_information
102: where
103: org_information_context = 'FR_HISTORICAL_MONTHLY_REF_HRS'
104: and organization_id = c_org_id
105: order by fnd_date.canonical_to_date(org_information1);

Line 347: from hr_organization_information

343: While i < l_assignments.last Loop
344: i := i + 1;
345: select to_number(org_information4)
346: into l_current_monthly_ref_hours
347: from hr_organization_information
348: where org_information_context = 'FR_ESTAB_INFO'
349: and organization_id = l_assignments(i).establishment_id;
350: l_monthly_hours.delete;
351: l_indx := 2;