APPS.GHR_CORR_CANC_SF52 dependencies on PER_ASSIGNMENTS_F

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

1717: l_deleted boolean;
1718: l_system_type per_person_types.system_person_type%type;
1719: l_prior_noa_code ghr_nature_of_actions.code%type;
1720: l_noa_family_code ghr_families.noa_family_code%type;
1721: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1722:
1723: -- bug #6312144
1724: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;

Line 1765: from per_assignments_f paf

1761: -- Bug#2780976 Modified the cursor c_prior_person_type
1762: -- Bug# 5442674 Modified the select statement
1763: Cursor c_prior_person_type is
1764: Select paf.assignment_id
1765: from per_assignments_f paf
1766: where paf.person_id = p_sf52_data.person_id
1767: and paf.assignment_type='E'
1768: and p_sf52_data.effective_date-1 between paf.effective_start_date and paf.effective_end_date;
1769:

Line 1812: from per_assignments_f

1808: --
1809: Cursor Cur_bg(p_person_id NUMBER,
1810: p_eff_date DATE) is
1811: Select distinct business_group_id bg
1812: from per_assignments_f
1813: where person_id = p_person_id
1814: and p_eff_date between effective_start_date
1815: and effective_end_date;
1816: --

Line 4172: FROM per_assignments_f

4168: CURSOR Cur_bg(p_person_id NUMBER,
4169: p_eff_date DATE)
4170: IS
4171: SELECT business_group_id bg
4172: FROM per_assignments_f
4173: WHERE person_id = p_person_id
4174: AND p_eff_Date between effective_start_Date
4175: AND effective_end_Date;
4176:

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

4590: -- p_dt_mode -> datetrack delete mode.
4591: -- p_date_effective -> effective date of delete.
4592: --
4593: -- Post Success:
4594: -- per_assignments_f row will have been deleted.
4595: --
4596: -- Post Failure:
4597: -- message will have been displayed to user explaining why the delete could not be completed.
4598: --

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

4607:
4608: PROCEDURE delete_asgn_row( p_assignment_id in varchar2,
4609: p_dt_mode in varchar2,
4610: p_date_effective in date) IS
4611: l_proc varchar2(72) := 'delete_per_assignments_f_row';
4612: l_ovn number;
4613: l_effective_start_date date;
4614: l_effective_end_date date;
4615: l_validation_start_date date;

Line 4623: FROM PER_ASSIGNMENTS_F

4619: -- this cursor gets the object_version_number given the assignment_id and effective_date.
4620: cursor c_get_ovn (cp_assignment_id in number,
4621: cp_date_effective in date) is
4622: SELECT object_version_number
4623: FROM PER_ASSIGNMENTS_F
4624: WHERE assignment_id = cp_assignment_id
4625: AND cp_date_effective between effective_start_date and effective_end_date;
4626:
4627: Cursor Cur_proposal_exists (p_assignment_id IN NUMBER,

Line 6565: l_asg_id per_assignments_f.assignment_id%type;

6561: where pa_request_id in
6562: ( select altered_pa_request_id from
6563: ghr_pa_requests where
6564: pa_request_id = p_corr_sf52_detail.pa_request_id);
6565: l_asg_id per_assignments_f.assignment_id%type;
6566:
6567:
6568: Begin
6569: