APPS.PER_PERUSE1L_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 150: PER_ASSIGNMENTS_F ASS,

146: ASS.LOCATION_ID,
147: HL.LOCATION_CODE
148: FROM
149: PER_PEOPLE_F PEO,
150: PER_ASSIGNMENTS_F ASS,
151: PER_JOBS_VL JOB,
152: HR_LOCATIONS_ALL HL
153: WHERE PEO.PERSON_ID = ASS.PERSON_ID
154: AND PEO.PER_INFORMATION1 is not null

Line 175: PER_ASSIGNMENTS_F ASS1

171: AND ASS.EFFECTIVE_START_DATE = (
172: SELECT
173: MAX(ASS1.EFFECTIVE_START_DATE)
174: FROM
175: PER_ASSIGNMENTS_F ASS1
176: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
177: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
178: AND ASS.PERSON_ID = ASS1.PERSON_ID
179: AND ASS1.ASSIGNMENT_TYPE = 'E'

Line 236: PER_ASSIGNMENTS_F ASS,

232: COUNT('ass')
233: INTO L_REPORT_EMPS
234: FROM
235: PER_PEOPLE_F PEO,
236: PER_ASSIGNMENTS_F ASS,
237: PER_JOBS_VL JOB
238: WHERE PEO.PERSON_ID = ASS.PERSON_ID
239: AND PEO.PER_INFORMATION1 is not null
240: AND PEO.PER_INFORMATION_CATEGORY = 'US'

Line 260: PER_ASSIGNMENTS_F ASS1

256: AND ASS.EFFECTIVE_START_DATE = (
257: SELECT
258: MAX(ASS1.EFFECTIVE_START_DATE)
259: FROM
260: PER_ASSIGNMENTS_F ASS1
261: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
262: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
263: AND ASS.PERSON_ID = ASS1.PERSON_ID
264: AND ASS1.ASSIGNMENT_TYPE = 'E'

Line 300: PER_ASSIGNMENTS_F ASS,

296: SELECT
297: COUNT('ass')
298: INTO L_COUNT_EMPS
299: FROM
300: PER_ASSIGNMENTS_F ASS,
301: PER_JOBS_VL JOB
302: WHERE JOB.JOB_INFORMATION_CATEGORY = 'US'
303: AND L_DATE_START <= NVL(JOB.DATE_TO
304: ,L_DATE_END)

Line 328: PER_ASSIGNMENTS_F ASS1

324: AND ASS.EFFECTIVE_START_DATE = (
325: SELECT
326: MAX(ASS1.EFFECTIVE_START_DATE)
327: FROM
328: PER_ASSIGNMENTS_F ASS1
329: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
330: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
331: AND ASS.PERSON_ID = ASS1.PERSON_ID
332: AND ASS1.ASSIGNMENT_TYPE = 'E'