APPS.GHR_SF52_DO_UPDATE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;

56: l_index varchar2(10);
57: l_extra_info_id number(15);
58: l_extra_info_rec ghr_api.extra_info_rec_type;
59: --
60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;
63: l_per_cre_ovn per_people_extra_info.object_version_number%type;
64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

Line 61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;

57: l_extra_info_id number(15);
58: l_extra_info_rec ghr_api.extra_info_rec_type;
59: --
60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;
63: l_per_cre_ovn per_people_extra_info.object_version_number%type;
64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
65: l_pos1_cre_ovn per_position_extra_info.object_version_number%type;

Line 105: from per_assignment_extra_info

101:
102: Cursor c_asg_ei is
103: select assignment_extra_info_id,
104: object_version_number
105: from per_assignment_extra_info
106: where assignment_id = l_id
107: and information_type = p_l_information_type;
108:
109: Cursor c_per_ei is

Line 1411: l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;

1407: NVL(par.first_noa_cancel_or_correct, 'NULL') <> 'CANCEL'
1408: ORDER BY effective_date ASC;
1409: */
1410: l_noa_code VARCHAR2(80);
1411: l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1412:
1413: --
1414: -- for bug 3191704
1415: CURSOR cur_rei_poi(p_par_id in NUMBER)

Line 1425: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;

1421:
1422: target_poi ghr_pa_requests.personnel_office_id%type;
1423: -- for bug 3191704
1424:
1425: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1426: ---------------------------------------------------------- added 2 cursors for 1274541
1427: --Begin Bug 5919705
1428: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1429: l_pay_plan ghr_pa_requests.to_pay_plan%type;

Line 1494: l_asg_ei_data per_assignment_extra_info%rowtype;

1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1491: --
1492: -- Bug 3390876
1493: l_np_eff_date ghr_pa_requests.effective_date%type;
1494: l_asg_ei_data per_assignment_extra_info%rowtype;
1495: Begin
1496: --
1497: hr_utility.set_location('Entering ' ||l_proc,5);
1498: hr_utility.set_location('CALL EXT INFOper_serv_oblig_flag '||p_per_service_oblig.per_service_oblig_flag,10);

Line 3358: l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;

3354: --
3355: --
3356: l_assgn_id NUMBER;
3357: l_eff_date DATE;
3358: l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
3359: l_active_flag varchar2(1);
3360: l_RTD_noa_code VARCHAR2(80);
3361: l_bg_id NUMBER;
3362: