eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MASS_SEL_NOA dependencies on PER_ASSIGNMENTS_F

Line 585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE

581: , p_mass_salary_name IN varchar2
582: , p_full_name IN per_people_f.full_name%TYPE
583: , p_national_identifier IN per_people_f.national_identifier%TYPE
584: , p_employee_number IN per_people_f.employee_number%TYPE
585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
586: , p_person_id IN per_assignments_f.person_id%TYPE
587: , p_position_id IN per_assignments_f.position_id%TYPE
588: , p_grade_id IN per_assignments_f.grade_id%TYPE
589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE

Line 586: , p_person_id IN per_assignments_f.person_id%TYPE

582: , p_full_name IN per_people_f.full_name%TYPE
583: , p_national_identifier IN per_people_f.national_identifier%TYPE
584: , p_employee_number IN per_people_f.employee_number%TYPE
585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
586: , p_person_id IN per_assignments_f.person_id%TYPE
587: , p_position_id IN per_assignments_f.position_id%TYPE
588: , p_grade_id IN per_assignments_f.grade_id%TYPE
589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
590: , p_location_id IN per_assignments_f.location_id%TYPE

Line 587: , p_position_id IN per_assignments_f.position_id%TYPE

583: , p_national_identifier IN per_people_f.national_identifier%TYPE
584: , p_employee_number IN per_people_f.employee_number%TYPE
585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
586: , p_person_id IN per_assignments_f.person_id%TYPE
587: , p_position_id IN per_assignments_f.position_id%TYPE
588: , p_grade_id IN per_assignments_f.grade_id%TYPE
589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
590: , p_location_id IN per_assignments_f.location_id%TYPE
591: , p_organization_id IN per_assignments_f.organization_id%TYPE

Line 588: , p_grade_id IN per_assignments_f.grade_id%TYPE

584: , p_employee_number IN per_people_f.employee_number%TYPE
585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
586: , p_person_id IN per_assignments_f.person_id%TYPE
587: , p_position_id IN per_assignments_f.position_id%TYPE
588: , p_grade_id IN per_assignments_f.grade_id%TYPE
589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
590: , p_location_id IN per_assignments_f.location_id%TYPE
591: , p_organization_id IN per_assignments_f.organization_id%TYPE
592: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE

Line 589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE

585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
586: , p_person_id IN per_assignments_f.person_id%TYPE
587: , p_position_id IN per_assignments_f.position_id%TYPE
588: , p_grade_id IN per_assignments_f.grade_id%TYPE
589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
590: , p_location_id IN per_assignments_f.location_id%TYPE
591: , p_organization_id IN per_assignments_f.organization_id%TYPE
592: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
593: , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 590: , p_location_id IN per_assignments_f.location_id%TYPE

586: , p_person_id IN per_assignments_f.person_id%TYPE
587: , p_position_id IN per_assignments_f.position_id%TYPE
588: , p_grade_id IN per_assignments_f.grade_id%TYPE
589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
590: , p_location_id IN per_assignments_f.location_id%TYPE
591: , p_organization_id IN per_assignments_f.organization_id%TYPE
592: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
593: , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
594: , p_mnoa_personnel_office_id IN varchar2

Line 591: , p_organization_id IN per_assignments_f.organization_id%TYPE

587: , p_position_id IN per_assignments_f.position_id%TYPE
588: , p_grade_id IN per_assignments_f.grade_id%TYPE
589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
590: , p_location_id IN per_assignments_f.location_id%TYPE
591: , p_organization_id IN per_assignments_f.organization_id%TYPE
592: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
593: , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
594: , p_mnoa_personnel_office_id IN varchar2
595: , p_mnoa_agency_code_subelement IN varchar2

Line 592: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE

588: , p_grade_id IN per_assignments_f.grade_id%TYPE
589: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
590: , p_location_id IN per_assignments_f.location_id%TYPE
591: , p_organization_id IN per_assignments_f.organization_id%TYPE
592: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
593: , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
594: , p_mnoa_personnel_office_id IN varchar2
595: , p_mnoa_agency_code_subelement IN varchar2
596: , p_mnoa_job_id IN number default NULL

Line 611: , p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%TYPE

607: , p_annuitant_indicator OUT NOCOPY varchar2
608: , p_pay_rate_determinant OUT NOCOPY varchar2
609: , p_work_schedule OUT NOCOPY varchar2
610: , p_part_time_hour OUT NOCOPY varchar2
611: , p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%TYPE
612: , p_pay_plan OUT NOCOPY varchar2
613: , p_to_pay_plan OUT NOCOPY varchar2
614: , p_pay_table_id OUT NOCOPY number
615: , p_grade_or_level OUT NOCOPY varchar2

Line 632: l_assignment_id per_assignments_f.assignment_id%TYPE;

628: AND pay_rate_determinant = cur_prd;
629:
630: l_row_cnt number DEFAULT 0;
631: l_pos_grp1_rec per_position_extra_info%ROWTYPE;
632: l_assignment_id per_assignments_f.assignment_id%TYPE;
633: l_person_id per_assignments_f.person_id%TYPE;
634: l_position_id per_assignments_f.position_id%TYPE;
635: l_grade_id per_assignments_f.grade_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 633: l_person_id per_assignments_f.person_id%TYPE;

629:
630: l_row_cnt number DEFAULT 0;
631: l_pos_grp1_rec per_position_extra_info%ROWTYPE;
632: l_assignment_id per_assignments_f.assignment_id%TYPE;
633: l_person_id per_assignments_f.person_id%TYPE;
634: l_position_id per_assignments_f.position_id%TYPE;
635: l_grade_id per_assignments_f.grade_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;
637: l_location_id per_assignments_f.location_id%TYPE;

Line 634: l_position_id per_assignments_f.position_id%TYPE;

630: l_row_cnt number DEFAULT 0;
631: l_pos_grp1_rec per_position_extra_info%ROWTYPE;
632: l_assignment_id per_assignments_f.assignment_id%TYPE;
633: l_person_id per_assignments_f.person_id%TYPE;
634: l_position_id per_assignments_f.position_id%TYPE;
635: l_grade_id per_assignments_f.grade_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;
637: l_location_id per_assignments_f.location_id%TYPE;
638: l_tenure varchar2(35);

Line 635: l_grade_id per_assignments_f.grade_id%TYPE;

631: l_pos_grp1_rec per_position_extra_info%ROWTYPE;
632: l_assignment_id per_assignments_f.assignment_id%TYPE;
633: l_person_id per_assignments_f.person_id%TYPE;
634: l_position_id per_assignments_f.position_id%TYPE;
635: l_grade_id per_assignments_f.grade_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;
637: l_location_id per_assignments_f.location_id%TYPE;
638: l_tenure varchar2(35);
639: l_annuitant_indicator varchar2(35);

Line 636: l_business_group_id per_assignments_f.business_group_id%TYPE;

632: l_assignment_id per_assignments_f.assignment_id%TYPE;
633: l_person_id per_assignments_f.person_id%TYPE;
634: l_position_id per_assignments_f.position_id%TYPE;
635: l_grade_id per_assignments_f.grade_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;
637: l_location_id per_assignments_f.location_id%TYPE;
638: l_tenure varchar2(35);
639: l_annuitant_indicator varchar2(35);
640: l_pay_rate_determinant varchar2(35);

Line 637: l_location_id per_assignments_f.location_id%TYPE;

633: l_person_id per_assignments_f.person_id%TYPE;
634: l_position_id per_assignments_f.position_id%TYPE;
635: l_grade_id per_assignments_f.grade_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;
637: l_location_id per_assignments_f.location_id%TYPE;
638: l_tenure varchar2(35);
639: l_annuitant_indicator varchar2(35);
640: l_pay_rate_determinant varchar2(35);
641: l_work_schedule varchar2(35);

Line 1450: (p_position_id IN per_assignments_f.position_id%TYPE

1446: hr_utility.set_location ('Leaving '|| l_proc, 100);
1447: END update_position_info;
1448:
1449: PROCEDURE get_pos_grp1_ddf
1450: (p_position_id IN per_assignments_f.position_id%TYPE
1451: , p_effective_date IN date
1452: , p_flsa_category OUT NOCOPY varchar2
1453: , p_barg_unit_status OUT NOCOPY varchar2
1454: , p_functional_class OUT NOCOPY varchar2 -- Bug# 14410401

Line 1498: l_assignment_id per_assignments_f.assignment_id%TYPE;

1494: , p_mass_salary_id IN number
1495: , p_action IN varchar2) IS
1496:
1497: p_mass_salary varchar2(32);
1498: l_assignment_id per_assignments_f.assignment_id%TYPE;
1499: l_position_id per_assignments_f.position_id%TYPE;
1500: l_grade_id per_assignments_f.grade_id%TYPE;
1501: l_business_group_id per_assignments_f.business_group_id%TYPE;
1502: l_position_title varchar2(300);

Line 1499: l_position_id per_assignments_f.position_id%TYPE;

1495: , p_action IN varchar2) IS
1496:
1497: p_mass_salary varchar2(32);
1498: l_assignment_id per_assignments_f.assignment_id%TYPE;
1499: l_position_id per_assignments_f.position_id%TYPE;
1500: l_grade_id per_assignments_f.grade_id%TYPE;
1501: l_business_group_id per_assignments_f.business_group_id%TYPE;
1502: l_position_title varchar2(300);
1503: l_position_number varchar2(20);

Line 1500: l_grade_id per_assignments_f.grade_id%TYPE;

1496:
1497: p_mass_salary varchar2(32);
1498: l_assignment_id per_assignments_f.assignment_id%TYPE;
1499: l_position_id per_assignments_f.position_id%TYPE;
1500: l_grade_id per_assignments_f.grade_id%TYPE;
1501: l_business_group_id per_assignments_f.business_group_id%TYPE;
1502: l_position_title varchar2(300);
1503: l_position_number varchar2(20);
1504: l_position_seq_no varchar2(20);

Line 1501: l_business_group_id per_assignments_f.business_group_id%TYPE;

1497: p_mass_salary varchar2(32);
1498: l_assignment_id per_assignments_f.assignment_id%TYPE;
1499: l_position_id per_assignments_f.position_id%TYPE;
1500: l_grade_id per_assignments_f.grade_id%TYPE;
1501: l_business_group_id per_assignments_f.business_group_id%TYPE;
1502: l_position_title varchar2(300);
1503: l_position_number varchar2(20);
1504: l_position_seq_no varchar2(20);
1505: l_recs_failed number DEFAULT 0;

Line 1632: FROM per_assignments_f paf

1628: , paf.location_id location_id
1629: , paf.organization_id organization_id
1630: , paf.business_group_id business_group_id
1631: , paf.assignment_status_type_id assignment_status_type_id
1632: FROM per_assignments_f paf
1633: , per_people_f ppf
1634: , per_person_types ppt
1635: , hr_organization_units hou
1636: , per_assignment_status_types past

Line 1675: FROM per_assignments_f paf

1671: , paf.location_id location_id
1672: , paf.organization_id organization_id
1673: , paf.business_group_id business_group_id
1674: , paf.assignment_status_type_id assignment_status_type_id
1675: FROM per_assignments_f paf
1676: , per_people_f ppf
1677: , per_person_types ppt
1678: , hr_organization_units hou
1679: , per_assignment_status_types past

Line 1715: FROM per_assignments_f paf

1711: , paf.location_id location_id
1712: , paf.organization_id organization_id
1713: , paf.business_group_id business_group_id
1714: , paf.assignment_status_type_id assignment_status_type_id
1715: FROM per_assignments_f paf
1716: , per_people_f ppf
1717: , per_person_types ppt
1718: , hr_organization_units hou
1719: , per_assignment_status_types past

Line 1755: FROM per_assignments_f paf

1751: , paf.location_id location_id
1752: , paf.organization_id organization_id
1753: , paf.business_group_id business_group_id
1754: , paf.assignment_status_type_id assignment_status_type_id
1755: FROM per_assignments_f paf
1756: , per_people_f ppf
1757: , per_person_types ppt
1758: , hr_organization_units hou
1759: , per_assignment_status_types past

Line 1795: FROM per_assignments_f paf

1791: , paf.location_id location_id
1792: , paf.organization_id organization_id
1793: , paf.business_group_id business_group_id
1794: , paf.assignment_status_type_id assignment_status_type_id
1795: FROM per_assignments_f paf
1796: , per_people_f ppf
1797: , per_person_types ppt
1798: , hr_organization_units hou
1799: , per_assignment_status_types past

Line 1835: FROM per_assignments_f paf

1831: , paf.location_id location_id
1832: , paf.organization_id organization_id
1833: , paf.business_group_id business_group_id
1834: , paf.assignment_status_type_id assignment_status_type_id
1835: FROM per_assignments_f paf
1836: , per_people_f ppf
1837: , per_person_types ppt
1838: , hr_organization_units hou
1839: , per_assignment_status_types past

Line 1876: FROM per_assignments_f paf

1872: , paf.location_id location_id
1873: , paf.organization_id organization_id
1874: , paf.business_group_id business_group_id
1875: , paf.assignment_status_type_id assignment_status_type_id
1876: FROM per_assignments_f paf
1877: , per_people_f ppf
1878: , per_person_types ppt
1879: , hr_organization_units hou
1880: WHERE ppf.person_id = paf.person_id

Line 1922: FROM per_people_f p, per_assignments_f a

1918: and pop.organization_id = punits.organization_id
1919: and not exists
1920: (
1921: SELECT 'X'
1922: FROM per_people_f p, per_assignments_f a
1923: WHERE trunc(effective_date) between a.effective_start_date and a.effective_end_date
1924: AND a.primary_flag = 'Y'
1925: AND a.assignment_type <> 'B'
1926: AND p.current_employee_flag = 'Y'

Line 2001: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1997: and l_effective_date between ds.effective_start_date
1998: and ds.effective_end_date;
1999:
2000: PROCEDURE vacant_pos_process
2001: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2002: , p_person_id IN per_assignments_f.person_id%TYPE
2003: , p_position_id IN per_assignments_f.position_id%TYPE
2004: , p_grade_id IN per_assignments_f.grade_id%TYPE
2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE

Line 2002: , p_person_id IN per_assignments_f.person_id%TYPE

1998: and ds.effective_end_date;
1999:
2000: PROCEDURE vacant_pos_process
2001: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2002: , p_person_id IN per_assignments_f.person_id%TYPE
2003: , p_position_id IN per_assignments_f.position_id%TYPE
2004: , p_grade_id IN per_assignments_f.grade_id%TYPE
2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2006: , p_location_id IN per_assignments_f.location_id%TYPE

Line 2003: , p_position_id IN per_assignments_f.position_id%TYPE

1999:
2000: PROCEDURE vacant_pos_process
2001: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2002: , p_person_id IN per_assignments_f.person_id%TYPE
2003: , p_position_id IN per_assignments_f.position_id%TYPE
2004: , p_grade_id IN per_assignments_f.grade_id%TYPE
2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2006: , p_location_id IN per_assignments_f.location_id%TYPE
2007: , p_organization_id IN per_assignments_f.organization_id%TYPE

Line 2004: , p_grade_id IN per_assignments_f.grade_id%TYPE

2000: PROCEDURE vacant_pos_process
2001: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2002: , p_person_id IN per_assignments_f.person_id%TYPE
2003: , p_position_id IN per_assignments_f.position_id%TYPE
2004: , p_grade_id IN per_assignments_f.grade_id%TYPE
2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2006: , p_location_id IN per_assignments_f.location_id%TYPE
2007: , p_organization_id IN per_assignments_f.organization_id%TYPE
2008: , p_date_of_birth IN date

Line 2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE

2001: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2002: , p_person_id IN per_assignments_f.person_id%TYPE
2003: , p_position_id IN per_assignments_f.position_id%TYPE
2004: , p_grade_id IN per_assignments_f.grade_id%TYPE
2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2006: , p_location_id IN per_assignments_f.location_id%TYPE
2007: , p_organization_id IN per_assignments_f.organization_id%TYPE
2008: , p_date_of_birth IN date
2009: , p_first_name IN per_people_f.first_name%TYPE

Line 2006: , p_location_id IN per_assignments_f.location_id%TYPE

2002: , p_person_id IN per_assignments_f.person_id%TYPE
2003: , p_position_id IN per_assignments_f.position_id%TYPE
2004: , p_grade_id IN per_assignments_f.grade_id%TYPE
2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2006: , p_location_id IN per_assignments_f.location_id%TYPE
2007: , p_organization_id IN per_assignments_f.organization_id%TYPE
2008: , p_date_of_birth IN date
2009: , p_first_name IN per_people_f.first_name%TYPE
2010: , p_last_name IN per_people_f.last_name%TYPE

Line 2007: , p_organization_id IN per_assignments_f.organization_id%TYPE

2003: , p_position_id IN per_assignments_f.position_id%TYPE
2004: , p_grade_id IN per_assignments_f.grade_id%TYPE
2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2006: , p_location_id IN per_assignments_f.location_id%TYPE
2007: , p_organization_id IN per_assignments_f.organization_id%TYPE
2008: , p_date_of_birth IN date
2009: , p_first_name IN per_people_f.first_name%TYPE
2010: , p_last_name IN per_people_f.last_name%TYPE
2011: , p_full_name IN per_people_f.full_name%TYPE

Line 2027: , p_to_grade_id IN per_assignments_f.grade_id%TYPE

2023: , p_annuitant_indicator IN varchar2
2024: , p_pay_rate_determinant IN varchar2
2025: , p_work_schedule IN varchar2
2026: , p_part_time_hour IN varchar2
2027: , p_to_grade_id IN per_assignments_f.grade_id%TYPE
2028: , p_pay_plan IN varchar2
2029: , p_to_pay_plan IN varchar2
2030: , p_pay_table_id IN number
2031: , p_grade_or_level IN varchar2

Line 2456: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2452: END vacant_pos_process;
2453:
2454:
2455: PROCEDURE mnoa_process
2456: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2457: , p_person_id IN per_assignments_f.person_id%TYPE
2458: , p_position_id IN per_assignments_f.position_id%TYPE
2459: , p_grade_id IN per_assignments_f.grade_id%TYPE
2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE

Line 2457: , p_person_id IN per_assignments_f.person_id%TYPE

2453:
2454:
2455: PROCEDURE mnoa_process
2456: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2457: , p_person_id IN per_assignments_f.person_id%TYPE
2458: , p_position_id IN per_assignments_f.position_id%TYPE
2459: , p_grade_id IN per_assignments_f.grade_id%TYPE
2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2461: , p_location_id IN per_assignments_f.location_id%TYPE

Line 2458: , p_position_id IN per_assignments_f.position_id%TYPE

2454:
2455: PROCEDURE mnoa_process
2456: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2457: , p_person_id IN per_assignments_f.person_id%TYPE
2458: , p_position_id IN per_assignments_f.position_id%TYPE
2459: , p_grade_id IN per_assignments_f.grade_id%TYPE
2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2461: , p_location_id IN per_assignments_f.location_id%TYPE
2462: , p_organization_id IN per_assignments_f.organization_id%TYPE

Line 2459: , p_grade_id IN per_assignments_f.grade_id%TYPE

2455: PROCEDURE mnoa_process
2456: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2457: , p_person_id IN per_assignments_f.person_id%TYPE
2458: , p_position_id IN per_assignments_f.position_id%TYPE
2459: , p_grade_id IN per_assignments_f.grade_id%TYPE
2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2461: , p_location_id IN per_assignments_f.location_id%TYPE
2462: , p_organization_id IN per_assignments_f.organization_id%TYPE
2463: , p_date_of_birth IN date

Line 2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE

2456: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2457: , p_person_id IN per_assignments_f.person_id%TYPE
2458: , p_position_id IN per_assignments_f.position_id%TYPE
2459: , p_grade_id IN per_assignments_f.grade_id%TYPE
2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2461: , p_location_id IN per_assignments_f.location_id%TYPE
2462: , p_organization_id IN per_assignments_f.organization_id%TYPE
2463: , p_date_of_birth IN date
2464: , p_first_name IN per_people_f.first_name%TYPE

Line 2461: , p_location_id IN per_assignments_f.location_id%TYPE

2457: , p_person_id IN per_assignments_f.person_id%TYPE
2458: , p_position_id IN per_assignments_f.position_id%TYPE
2459: , p_grade_id IN per_assignments_f.grade_id%TYPE
2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2461: , p_location_id IN per_assignments_f.location_id%TYPE
2462: , p_organization_id IN per_assignments_f.organization_id%TYPE
2463: , p_date_of_birth IN date
2464: , p_first_name IN per_people_f.first_name%TYPE
2465: , p_last_name IN per_people_f.last_name%TYPE

Line 2462: , p_organization_id IN per_assignments_f.organization_id%TYPE

2458: , p_position_id IN per_assignments_f.position_id%TYPE
2459: , p_grade_id IN per_assignments_f.grade_id%TYPE
2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2461: , p_location_id IN per_assignments_f.location_id%TYPE
2462: , p_organization_id IN per_assignments_f.organization_id%TYPE
2463: , p_date_of_birth IN date
2464: , p_first_name IN per_people_f.first_name%TYPE
2465: , p_last_name IN per_people_f.last_name%TYPE
2466: , p_full_name IN per_people_f.full_name%TYPE

Line 2482: , p_to_grade_id IN per_assignments_f.grade_id%TYPE

2478: , p_annuitant_indicator IN varchar2
2479: , p_pay_rate_determinant IN varchar2
2480: , p_work_schedule IN varchar2
2481: , p_part_time_hour IN varchar2
2482: , p_to_grade_id IN per_assignments_f.grade_id%TYPE
2483: , p_pay_plan IN varchar2
2484: , p_to_pay_plan IN varchar2
2485: , p_pay_table_id IN number
2486: , p_grade_or_level IN varchar2

Line 4471: l_organization_id per_assignments_f.organization_id%TYPE;

4467: , p_effective_date IN date) IS
4468: l_session_id number;
4469: l_sess_date date;
4470: --Begin Bug# 16083971
4471: l_organization_id per_assignments_f.organization_id%TYPE;
4472: CURSOR c_org_id(l_per_id in per_assignments_f.person_id%TYPE) IS
4473: SELECT asg.organization_id
4474: FROM per_all_assignments_f asg
4475: WHERE asg.person_id = l_per_id

Line 4472: CURSOR c_org_id(l_per_id in per_assignments_f.person_id%TYPE) IS

4468: l_session_id number;
4469: l_sess_date date;
4470: --Begin Bug# 16083971
4471: l_organization_id per_assignments_f.organization_id%TYPE;
4472: CURSOR c_org_id(l_per_id in per_assignments_f.person_id%TYPE) IS
4473: SELECT asg.organization_id
4474: FROM per_all_assignments_f asg
4475: WHERE asg.person_id = l_per_id
4476: AND asg.assignment_type <> 'B'