APPS.PAY_SA_GOSI_REPORTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 207: from hr_all_organization_units

203: and org_information_context = 'SA_EMPLOYER_GOSI_DETAILS';
204: --Cursor to get the name of the organization.
205: cursor get_org_name (p_org_id number) is
206: select name
207: from hr_all_organization_units
208: where organization_id = p_org_id;
209: /********************-- Cursor to get person ids of the newly hired employees
210: cursor get_pid_new (p_org_id number,p_date date) is
211: select distinct asg.person_id,paa.assignment_action_id

Line 490: from hr_all_organization_units

486: hr_utility.set_location('Before Hierarchy logic',10);
487: begin
488: select organization_id
489: into l_gre_id
490: from hr_all_organization_units
491: where name = l_gre_name
492: and business_group_id = p_business_group_id;
493: exception
494: when others then

Line 532: from hr_all_organization_units

528: hr_sa_org_info.get_employer_name(p_organisation_id,l_gre_name,p_business_group_id);
529: begin
530: select organization_id
531: into l_gre_id
532: from hr_all_organization_units
533: where name = l_gre_name
534: and business_group_id =p_business_group_id;
535: exception
536: when others then

Line 547: from hr_all_organization_units

543: l_gre_id := p_organisation_id;
544: begin
545: select name
546: into l_gre_name
547: from hr_all_organization_units
548: where organization_id= l_gre_id
549: and business_group_id =p_business_group_id;
550: exception
551: when others then

Line 1394: from hr_all_organization_units

1390: hr_sa_org_info.get_employer_name(rec_org_id.org,l_gre_name,p_business_group_id,p_org_structure_version_id);
1391: begin
1392: select organization_id
1393: into l_gre_id
1394: from hr_all_organization_units
1395: where name = l_gre_name
1396: and business_group_id = p_business_group_id;
1397: exception
1398: when others then

Line 1478: from hr_all_organization_units

1474: hr_sa_org_info.get_employer_name(p_organisation_id,l_gre_name,p_business_group_id);
1475: begin
1476: select organization_id
1477: into l_gre_id
1478: from hr_all_organization_units
1479: where name = l_gre_name
1480: and business_group_id = p_business_group_id;
1481: exception
1482: when others then

Line 1493: from hr_all_organization_units

1489: l_gre_id := p_organisation_id;
1490: begin
1491: select name
1492: into l_gre_name
1493: from hr_all_organization_units
1494: where organization_id= l_gre_id
1495: and business_group_id =p_business_group_id;
1496: exception
1497: when others then

Line 1522: from hr_all_organization_units

1518: close csr_gosi_code;
1519: begin
1520: select name
1521: into l_gosi_office
1522: from hr_all_organization_units
1523: where organization_id = l_gosi_office_id;
1524: exception
1525: when others then
1526: l_err := 1;

Line 2803: from hr_locations hl, hr_all_organization_units hau

2799: AND rowid = (select max(rowid) from per_people_extra_info where person_id = l_person_id ) ;
2800: --cursor to get employers town or city
2801: CURSOR csr_get_work_location (l_organization_id number) IS
2802: select town_or_city
2803: from hr_locations hl, hr_all_organization_units hau
2804: where hau.organization_id = l_organization_id
2805: and hau.location_id = hl.location_id;
2806: /*Cursor to get Start and Termination date of employee*/
2807: cursor get_start_date (l_assignment_id NUMBER, l_effective_date Date) is