APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_ASSIGNMENTS_F

Line 23: l_assignment_id per_assignments_f.assignment_id%type;

19: FROM per_all_assignments_f
20: WHERE person_id = p_person_id
21: AND p_effective_date between effective_start_date AND effective_end_date;
22:
23: l_assignment_id per_assignments_f.assignment_id%type;
24: l_asg_ei_data per_assignment_extra_info%rowtype;
25: l_session ghr_history_api.g_session_var_type;
26: l_session1 ghr_history_api.g_session_var_type;
27: --End Bug 5923620

Line 468: p_assignment_id in per_assignments_f.assignment_id%type ,

464: (p_pa_request_id in number ,
465: p_first_noa_id in number ,
466: p_second_noa_id in number ,
467: p_person_id in per_people_f.person_id%type ,
468: p_assignment_id in per_assignments_f.assignment_id%type ,
469: p_position_id in per_positions.position_id%type ,
470: p_effective_date in ghr_pa_requests.effective_date%type ,
471: p_refresh_flag in varchar2 default 'Y'
472: )

Line 632: p_assignment_id in per_assignments_f.assignment_id%type,

628: Procedure fetch_noa_spec_extra_info
629: (p_pa_request_id in number,
630: p_noa_id in number,
631: p_person_id in per_people_f.person_id%type,
632: p_assignment_id in per_assignments_f.assignment_id%type,
633: p_position_id in per_positions.position_id%type,
634: p_effective_date in ghr_pa_requests.effective_date%type,
635: p_refresh_flag in varchar2 default 'Y'
636: )

Line 656: l_assignment_id per_assignments_f.assignment_id%type;

652: l_flag varchar2(1);
653: l_refresh_flag varchar2(1);
654: l_rei_rec_exists varchar2(1);
655: l_person_id per_people_f.person_id%type;
656: l_assignment_id per_assignments_f.assignment_id%type;
657: l_ret_review_date varchar2(30);
658: l_eff_date date;
659: l_position_id per_positions.position_id%type;
660: l_per_refresh_flag varchar2(1);

Line 3462: l_assignment_id per_assignments_f.assignment_id%type;

3458: l_flag varchar2(1) := null;
3459: l_rei_rec ghr_pa_request_extra_info%rowtype;
3460: l_org_rec ghr_pa_request_ei_shadow%rowtype;
3461: l_person_id per_people_f.person_id%type;
3462: l_assignment_id per_assignments_f.assignment_id%type;
3463: l_per_refresh_flag varchar2(1);
3464: l_asg_refresh_flag varchar2(1);
3465: l_business_group_id per_assignments_f.business_group_id%type;
3466: l_noa_family_code ghr_noa_families.noa_family_code%type;

Line 3465: l_business_group_id per_assignments_f.business_group_id%type;

3461: l_person_id per_people_f.person_id%type;
3462: l_assignment_id per_assignments_f.assignment_id%type;
3463: l_per_refresh_flag varchar2(1);
3464: l_asg_refresh_flag varchar2(1);
3465: l_business_group_id per_assignments_f.business_group_id%type;
3466: l_noa_family_code ghr_noa_families.noa_family_code%type;
3467:
3468: l_proc varchar2(72) := g_package || 'fetch_gneric_extra_info';
3469: l_information_type ghr_pa_request_extra_info.information_type%type;

Line 3553: from per_assignments_f asg

3549: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
3550:
3551: cursor c_payroll is
3552: select payroll_id
3553: from per_assignments_f asg
3554: where asg.assignment_id = l_assignment_id
3555: and trunc(nvl(p_effective_date,sysdate))
3556: between asg.effective_start_date
3557: and asg.effective_end_date;