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_NL_IZA_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 138: ,per_all_assignments_f paa

134: ,pap.date_of_birth
135: ,pap.per_information15
136: FROM
137: per_all_people_f pap
138: ,per_all_assignments_f paa
139: WHERE pap.business_group_id = v_business_group_id
140: and pap.person_id = v_person_id
141: and pap.person_id = paa.person_id
142: and v_period_end_date between pap.effective_start_date and pap.effective_end_date

Line 146: FROM per_assignment_status_types past, per_all_assignments_f asg

142: and v_period_end_date between pap.effective_start_date and pap.effective_end_date
143: and paa.effective_start_date =
144: (
145: SELECT MIN(asg.effective_start_date)
146: FROM per_assignment_status_types past, per_all_assignments_f asg
147: WHERE asg.assignment_id = paa.assignment_id
148: and past.per_system_status = 'ACTIVE_ASSIGN'
149: and asg.assignment_status_type_id = past.assignment_status_type_id
150: and asg.effective_start_date <= v_period_End_Date

Line 164: ,per_all_assignments_f paa

160: SELECT
161: pap.person_id person_id
162: FROM
163: per_all_people_f pap
164: ,per_all_assignments_f paa
165: ,PER_ASSIGNMENT_EXTRA_INFO pae_iza
166: ,PER_ASSIGNMENT_EXTRA_INFO pae_sii
167: WHERE pap.business_group_id = v_business_group_id
168: and pap.person_id = paa.person_id

Line 174: FROM per_assignment_status_types past, per_all_assignments_f asg

170: and v_period_end_date between pap.effective_start_date and pap.effective_end_date
171: and paa.effective_start_date =
172: (
173: SELECT MIN(asg.effective_start_date)
174: FROM per_assignment_status_types past, per_all_assignments_f asg
175: WHERE asg.assignment_id = paa.assignment_id
176: and past.per_system_status = 'ACTIVE_ASSIGN'
177: and asg.assignment_status_type_id = past.assignment_status_type_id
178: and asg.effective_start_date <= v_period_End_Date

Line 1411: ,per_all_assignments_f paa

1407:
1408: cursor csr_emp_num_exists(v_employee_num varchar2,v_bg_id number,v_period_start_date date,v_period_end_date date) IS
1409: SELECT pap.person_id,paa.assignment_id,paa.assignment_number
1410: FROM per_all_people_f pap
1411: ,per_all_assignments_f paa
1412: WHERE ltrim(substr(pap.employee_number,1,9),'0') = v_employee_num
1413: AND paa.person_id = pap.person_id
1414: AND pap.business_group_id = v_bg_id
1415: AND v_period_end_date >= pap.effective_start_date

Line 1449: from per_all_assignments_f paa

1445:
1446:
1447: cursor csr_exchange_num_valid (v_org_id number,v_bg_id number,v_person_id number,v_period_start_date date,v_period_end_date date) IS
1448: select paa.assignment_id, paa.assignment_number
1449: from per_all_assignments_f paa
1450: where paa.person_id = v_person_id
1451: and paa.primary_flag = 'Y'
1452: and paa.business_group_id = v_bg_id
1453: and hr_nl_org_info.Get_iza_Org_Id(p_org_struct_version_id,paa.organization_id) = v_org_id

Line 1457: FROM per_assignment_status_types past, per_all_assignments_f asg

1453: and hr_nl_org_info.Get_iza_Org_Id(p_org_struct_version_id,paa.organization_id) = v_org_id
1454: and paa.effective_start_date =
1455: (
1456: SELECT MIN(asg.effective_start_date)
1457: FROM per_assignment_status_types past, per_all_assignments_f asg
1458: WHERE asg.assignment_id = paa.assignment_id
1459: and past.per_system_status = 'ACTIVE_ASSIGN'
1460: and asg.assignment_status_type_id = past.assignment_status_type_id
1461: and asg.effective_start_date <= v_period_end_date