APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_ASSIGNMENTS_F

Line 31: l_assignment_id per_assignments_f.assignment_id%type;

27: FROM per_all_assignments_f
28: WHERE person_id = p_person_id
29: AND p_effective_date between effective_start_date AND effective_end_date;
30:
31: l_assignment_id per_assignments_f.assignment_id%type;
32: l_asg_ei_data per_assignment_extra_info%rowtype;
33: l_session ghr_history_api.g_session_var_type;
34: l_session1 ghr_history_api.g_session_var_type;
35: --End Bug 5923620

Line 515: p_assignment_id in per_assignments_f.assignment_id%type ,

511: (p_pa_request_id in number ,
512: p_first_noa_id in number ,
513: p_second_noa_id in number ,
514: p_person_id in per_people_f.person_id%type ,
515: p_assignment_id in per_assignments_f.assignment_id%type ,
516: p_position_id in per_positions.position_id%type ,
517: p_effective_date in ghr_pa_requests.effective_date%type ,
518: p_refresh_flag in varchar2 default 'Y'
519: )

Line 691: p_assignment_id in per_assignments_f.assignment_id%type,

687: Procedure fetch_noa_spec_extra_info
688: (p_pa_request_id in number,
689: p_noa_id in number,
690: p_person_id in per_people_f.person_id%type,
691: p_assignment_id in per_assignments_f.assignment_id%type,
692: p_position_id in per_positions.position_id%type,
693: p_effective_date in ghr_pa_requests.effective_date%type,
694: p_refresh_flag in varchar2 default 'Y'
695: )

Line 715: l_assignment_id per_assignments_f.assignment_id%type;

711: l_flag varchar2(1);
712: l_refresh_flag varchar2(1);
713: l_rei_rec_exists varchar2(1);
714: l_person_id per_people_f.person_id%type;
715: l_assignment_id per_assignments_f.assignment_id%type;
716: l_ret_review_date varchar2(30);
717: l_eff_date date;
718: l_position_id per_positions.position_id%type;
719: l_per_refresh_flag varchar2(1);

Line 4219: l_assignment_id per_assignments_f.assignment_id%type;

4215: l_flag varchar2(1) := null;
4216: l_rei_rec ghr_pa_request_extra_info%rowtype;
4217: l_org_rec ghr_pa_request_ei_shadow%rowtype;
4218: l_person_id per_people_f.person_id%type;
4219: l_assignment_id per_assignments_f.assignment_id%type;
4220: l_per_refresh_flag varchar2(1);
4221: l_asg_refresh_flag varchar2(1);
4222: l_business_group_id per_assignments_f.business_group_id%type;
4223: l_noa_family_code ghr_noa_families.noa_family_code%type;

Line 4222: l_business_group_id per_assignments_f.business_group_id%type;

4218: l_person_id per_people_f.person_id%type;
4219: l_assignment_id per_assignments_f.assignment_id%type;
4220: l_per_refresh_flag varchar2(1);
4221: l_asg_refresh_flag varchar2(1);
4222: l_business_group_id per_assignments_f.business_group_id%type;
4223: l_noa_family_code ghr_noa_families.noa_family_code%type;
4224:
4225: l_proc varchar2(72) := g_package || 'fetch_generic_extra_info';
4226: l_information_type ghr_pa_request_extra_info.information_type%type;

Line 4310: from per_assignments_f asg

4306: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
4307:
4308: cursor c_payroll is
4309: select payroll_id
4310: from per_assignments_f asg
4311: where asg.assignment_id = l_assignment_id
4312: and trunc(nvl(p_effective_date,sysdate))
4313: between asg.effective_start_date
4314: and asg.effective_end_date;