APPS.PER_FR_D2_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 420: l_hours_text hr_organization_information.org_information4%type;

416: --
417: function get_estab_hours (p_establishment_id in number)
418: return number
419: is
420: l_hours_text hr_organization_information.org_information4%type;
421: l_hours number;
422: begin
423: --#3464382 Changed the query to fetch the data from the table and not from the view
424: select org_information4

Line 426: from hr_organization_information

422: begin
423: --#3464382 Changed the query to fetch the data from the table and not from the view
424: select org_information4
425: into l_hours_text
426: from hr_organization_information
427: where organization_id = p_establishment_id
428: and org_information_context = 'FR_ESTAB_INFO';
429: --
430: l_hours := fnd_number.canonical_to_number(l_hours_text);

Line 1277: hr_organization_information org,

1273: from per_all_people_f per,
1274: per_contracts_f ctr,
1275: hr_soft_coding_keyflex scl,
1276: per_all_positions pos,
1277: hr_organization_information org,
1278: hr_organization_information bus,
1279: per_assignment_budget_values_f bud,
1280: per_all_assignments_f asg
1281: where asg.assignment_id = p_assignment_id

Line 1278: hr_organization_information bus,

1274: per_contracts_f ctr,
1275: hr_soft_coding_keyflex scl,
1276: per_all_positions pos,
1277: hr_organization_information org,
1278: hr_organization_information bus,
1279: per_assignment_budget_values_f bud,
1280: per_all_assignments_f asg
1281: where asg.assignment_id = p_assignment_id
1282: and p_start_date between asg.effective_start_date