APPS.PER_GB_PENSRV_SVPN dependencies on PER_ALL_ASSIGNMENTS_F

Line 44: FROM per_all_assignments_f

40: CURSOR get_bg_id(c_assignment_id NUMBER,
41: c_effective_date DATE)
42: IS
43: SELECT business_group_id
44: FROM per_all_assignments_f
45: WHERE assignment_id = c_assignment_id
46: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
47:
48:

Line 76: per_all_assignments_f paaf,

72: CURSOR cur_get_svpn(c_ni_number VARCHAR2)
73: IS
74: SELECT max(to_number(paei.aei_information1))+1
75: FROM per_all_people_f papf,
76: per_all_assignments_f paaf,
77: per_assignment_extra_info paei
78: WHERE papf.NATIONAL_IDENTIFIER = c_ni_number
79: AND papf.person_id = paaf.person_id
80: AND paei.assignment_id = paaf.assignment_id

Line 89: per_all_assignments_f paaf1

85: c_effective_date DATE)
86: IS
87: SELECT papf1.NATIONAL_IDENTIFIER
88: FROM per_all_people_f papf1,
89: per_all_assignments_f paaf1
90: WHERE paaf1.assignment_id = c_assignment_id
91: AND c_effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
92: AND papf1.person_id = paaf1.person_id
93: AND c_effective_date BETWEEN papf1.effective_start_date AND papf1.effective_end_date;

Line 111: FROM per_all_assignments_f paaf

107: CURSOR csr_get_asg_detials(c_assignment_id NUMBER,
108: c_effective_date DATE)
109: IS
110: SELECT paaf.primary_flag
111: FROM per_all_assignments_f paaf
112: WHERE paaf.assignment_id = c_assignment_id
113: AND c_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
114:
115: BEGIN

Line 163: 'from per_all_assignments_f'||' '||

159:
160:
161: -- Query to fetch configured value for the assignment.
162: l_query := 'select '||l_column_name||' '||
163: 'from per_all_assignments_f'||' '||
164: 'where business_group_id = '||l_bg_id||' '||
165: 'and assignment_id = '||g_assignment_id||' ';
166: IF l_ass_attribute_category <> 'Global Data Elements' THEN
167: l_query := l_query||