APPS.GHR_CORR_CANC_SF52 dependencies on PER_ASSIGNMENTS_F

Line 1552: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674

1548: l_deleted boolean;
1549: l_system_type per_person_types.system_person_type%type;
1550: l_prior_noa_code ghr_nature_of_actions.code%type;
1551: l_noa_family_code ghr_families.noa_family_code%type;
1552: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1553:
1554: -- bug #6312144
1555: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1556: l_imm_retirement_info ghr_api.per_retirement_info_type;

Line 1592: from per_assignments_f paf

1588: -- Bug#2780976 Modified the cursor c_prior_person_type
1589: -- Bug# 5442674 Modified the select statement
1590: Cursor c_prior_person_type is
1591: Select paf.assignment_id
1592: from per_assignments_f paf
1593: where paf.person_id = p_sf52_data.person_id
1594: and paf.assignment_type='E'
1595: and p_sf52_data.effective_date-1 between paf.effective_start_date and paf.effective_end_date;
1596:

Line 1639: from per_assignments_f

1635: --
1636: Cursor Cur_bg(p_person_id NUMBER,
1637: p_eff_date DATE) is
1638: Select distinct business_group_id bg
1639: from per_assignments_f
1640: where person_id = p_person_id
1641: and p_eff_date between effective_start_date
1642: and effective_end_date;
1643: --

Line 3864: FROM per_assignments_f

3860: CURSOR Cur_bg(p_person_id NUMBER,
3861: p_eff_date DATE)
3862: IS
3863: SELECT business_group_id bg
3864: FROM per_assignments_f
3865: WHERE person_id = p_person_id
3866: AND p_eff_Date between effective_start_Date
3867: AND effective_end_Date;
3868:

Line 4252: -- per_assignments_f row will have been deleted.

4248: -- p_dt_mode -> datetrack delete mode.
4249: -- p_date_effective -> effective date of delete.
4250: --
4251: -- Post Success:
4252: -- per_assignments_f row will have been deleted.
4253: --
4254: -- Post Failure:
4255: -- message will have been displayed to user explaining why the delete could not be completed.
4256: --

Line 4269: l_proc varchar2(72) := 'delete_per_assignments_f_row';

4265:
4266: PROCEDURE delete_asgn_row( p_assignment_id in varchar2,
4267: p_dt_mode in varchar2,
4268: p_date_effective in date) IS
4269: l_proc varchar2(72) := 'delete_per_assignments_f_row';
4270: l_ovn number;
4271: l_effective_start_date date;
4272: l_effective_end_date date;
4273: l_validation_start_date date;

Line 4281: FROM PER_ASSIGNMENTS_F

4277: -- this cursor gets the object_version_number given the assignment_id and effective_date.
4278: cursor c_get_ovn (cp_assignment_id in number,
4279: cp_date_effective in date) is
4280: SELECT object_version_number
4281: FROM PER_ASSIGNMENTS_F
4282: WHERE assignment_id = cp_assignment_id
4283: AND cp_date_effective between effective_start_date and effective_end_date;
4284:
4285: Cursor Cur_proposal_exists (p_assignment_id IN NUMBER,

Line 6210: l_asg_id per_assignments_f.assignment_id%type;

6206: where pa_request_id in
6207: ( select altered_pa_request_id from
6208: ghr_pa_requests where
6209: pa_request_id = p_corr_sf52_detail.pa_request_id);
6210: l_asg_id per_assignments_f.assignment_id%type;
6211:
6212:
6213: Begin
6214: