eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 17: FROM per_all_assignments_f

13: ,p_rate_id IN NUMBER)
14: RETURN NUMBER AS
15: CURSOR csr_get_grade IS
16: SELECT grade_id
17: FROM per_all_assignments_f
18: WHERE assignment_id = p_assignment_id
19: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
20: l_grade_id NUMBER;
21:

Line 65: FROM per_all_assignments_f

61: ,p_table_exists OUT NOCOPY VARCHAR2)
62: RETURN NUMBER AS
63: CURSOR csr_get_grade IS
64: SELECT grade_id
65: FROM per_all_assignments_f
66: WHERE assignment_id = p_assignment_id
67: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
68: l_grade_id NUMBER;
69:

Line 144: ,per_all_assignments_f asg

140: SELECT paa.date_start start_date
141: ,paa.date_end end_date
142: FROM per_absence_attendances paa
143: ,per_absence_attendance_types paat
144: ,per_all_assignments_f asg
145: WHERE paat.absence_category ='UL'
146: AND paat.business_group_id = paa.business_group_id
147: AND paat.business_group_id = p_business_group_id
148: AND paat.absence_attendance_type_id = paa.absence_attendance_type_id

Line 158: ,per_all_assignments_f asg

154: SELECT paa.date_start start_date
155: ,p_end_date end_date
156: FROM per_absence_attendances paa
157: ,per_absence_attendance_types paat
158: ,per_all_assignments_f asg
159: WHERE paat.absence_category ='UL'
160: AND paat.business_group_id = paa.business_group_id
161: AND paat.business_group_id = p_business_group_id
162: AND paat.absence_attendance_type_id = paa.absence_attendance_type_id

Line 172: ,per_all_assignments_f asg

168: SELECT p_start_date start_date
169: ,paa.date_end end_date
170: FROM per_absence_attendances paa
171: ,per_absence_attendance_types paat
172: ,per_all_assignments_f asg
173: WHERE paat.absence_category ='UL'
174: AND paat.business_group_id = paa.business_group_id
175: AND paat.business_group_id = p_business_group_id
176: AND paat.absence_attendance_type_id = paa.absence_attendance_type_id

Line 186: ,per_all_assignments_f asg

182: SELECT p_start_date start_date
183: ,p_end_date end_date
184: FROM per_absence_attendances paa
185: ,per_absence_attendance_types paat
186: ,per_all_assignments_f asg
187: WHERE paat.absence_category ='UL'
188: AND paat.business_group_id = paa.business_group_id
189: AND paat.business_group_id = p_business_group_id
190: AND paat.absence_attendance_type_id = paa.absence_attendance_type_id

Line 244: ,per_all_assignments_f asg

240: RETURN VARCHAR2 AS
241: CURSOR csr_get_marital_status IS
242: SELECT marital_status
243: FROM per_all_people_f ppl
244: ,per_all_assignments_f asg
245: WHERE asg.assignment_id = p_assignment_id
246: AND ppl.person_id = asg.person_id
247: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date
248: AND p_date_earned BETWEEN ppl.effective_start_date AND ppl.effective_end_date;

Line 253: ,per_all_assignments_f asg

249:
250: CURSOR csr_get_dependent_children IS
251: SELECT COUNT(DISTINCT contact_person_id)
252: FROM per_contact_relationships pcr
253: ,per_all_assignments_f asg
254: WHERE asg.person_id = pcr.person_id
255: AND asg.assignment_id = p_assignment_id
256: AND pcr.contact_type = 'C'
257: AND nvl(pcr.dependent_flag, 'N') = 'Y'