APPS.GHR_MTO_INT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1814: p_a per_all_assignments_f%rowtype)

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

Line 2056: p_a per_all_assignments_f%rowtype)

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

Line 4081: l_assignments_row per_all_assignments_f%rowtype;

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

Line 4085: from per_all_assignments_f

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