APPS.GHR_MTO_INT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1813: p_a per_all_assignments_f%rowtype)

1809: end;
1810:
1811: procedure insert_assignment_f(p_transfer_name varchar2,
1812: p_effective_date date,
1813: p_a per_all_assignments_f%rowtype)
1814: is
1815:
1816: l_proc varchar2(72) := g_package||'insert_assignment';
1817: l_table_name constant varchar2(30) := 'PER_ASSIGNMENTS_F';

Line 2055: p_a per_all_assignments_f%rowtype)

2051: end;
2052:
2053: procedure update_assignment_f(p_transfer_name varchar2,
2054: p_effective_date date,
2055: p_a per_all_assignments_f%rowtype)
2056: is
2057:
2058: l_proc varchar2(72) := g_package||'insert_assignment';
2059: l_x varchar2(1);

Line 4080: l_assignments_row per_all_assignments_f%rowtype;

4076: and l_effdate
4077: between nvl(date_from,l_effdate)
4078: and nvl(date_to,l_effdate);
4079:
4080: l_assignments_row per_all_assignments_f%rowtype;
4081: l_assignment_ei_row per_assignment_extra_info%rowtype;
4082: cursor cur_assignments_f(p_person_id number) is
4083: select assignment_id, position_id, business_group_id, grade_id, location_id
4084: from per_all_assignments_f

Line 4084: from per_all_assignments_f

4080: l_assignments_row per_all_assignments_f%rowtype;
4081: l_assignment_ei_row per_assignment_extra_info%rowtype;
4082: cursor cur_assignments_f(p_person_id number) is
4083: select assignment_id, position_id, business_group_id, grade_id, location_id
4084: from per_all_assignments_f
4085: where primary_flag = 'Y'
4086: and assignment_type <> 'B'
4087: and person_id = p_person_id
4088: and trunc(l_effdate) between effective_start_date