APPS.PQH_FR_EMP_STAT_SITUATION_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 42: FROM per_all_assignments_f asg,

38: asg.assignment_status_type_id,
39: ast.per_system_status,
40: ast.pay_system_status,
41: asg.object_version_number
42: FROM per_all_assignments_f asg,
43: per_assignment_status_types ast
44: WHERE asg.person_id = p_person_id
45: AND p_eff_date BETWEEN asg.effective_start_date AND asg.effective_end_date
46: AND asg.primary_flag = 'Y'

Line 56: FROM per_all_assignments_f asg,

52: effective_start_date,
53: effective_end_date,
54: assignment_type,
55: asg.object_version_number
56: FROM per_all_assignments_f asg,
57: hr_soft_coding_keyflex scl,
58: per_assignment_status_types ast
59: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
60: AND scl.segment26 = p_career_id

Line 71: FROM per_all_assignments_f asg,

67: --Cursor to check if Affectation Assignment is Terminated in Future.
68: CURSOR csr_invalid_term_assign(p_affect_asg_id IN NUMBER,
69: p_term_st_dt IN DATE) IS
70: SELECT 'Y'
71: FROM per_all_assignments_f asg,
72: per_assignment_status_types ast
73: where asg.assignment_id = p_affect_asg_id
74: and asg.effective_end_date >= p_term_st_dt
75: and ast.assignment_status_type_id = asg.assignment_status_type_id

Line 144: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'

140: END IF;
141: l_affect_asg_id := lr_affectations.assignment_id;
142: l_affect_ovn := lr_affectations.object_version_number;
143: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => l_eff_dt
144: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
145: ,p_base_key_column => 'ASSIGNMENT_ID'
146: ,p_base_key_value => l_affect_asg_id);
147: --
148: IF lr_affectations.assignment_type = 'E' THEN

Line 171: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'

167: --
168: END LOOP;
169: --
170: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => p_start_date
171: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
172: ,p_base_key_column => 'ASSIGNMENT_ID'
173: ,p_base_key_value => lr_career_rec.assignment_id);
174: --
175: IF lr_career_rec.assignment_type = 'C' THEN

Line 212: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'

208: END IF;
209: l_affect_asg_id := lr_affectations.assignment_id;
210: l_affect_ovn := lr_affectations.object_version_number;
211: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => l_eff_dt
212: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
213: ,p_base_key_column => 'ASSIGNMENT_ID'
214: ,p_base_key_value => lr_affectations.assignment_id);
215: --
216: IF lr_affectations.assignment_type = 'E' THEN

Line 292: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'

288: --
289: END LOOP;
290: --
291: l_dt_mode := pqh_fr_utility.get_datetrack_mode(p_effective_date => p_start_date
292: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
293: ,p_base_key_column => 'ASSIGNMENT_ID'
294: ,p_base_key_value => lr_career_rec.assignment_id);
295: --
296: IF lr_sit_dtls.remuneration_paid = 'Y' AND lr_sit_dtls.remunerate_assign_status_id = -1 THEN