DBA Data[Home] [Help]

APPS.PER_PERUSEOC_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 344: PER_ASSIGNMENTS_F ASS,

340: JOB.NAME JOB_NAME,
341: ASS.JOB_ID
342: FROM
343: PER_ALL_PEOPLE_F PEO,
344: PER_ASSIGNMENTS_F ASS,
345: PER_JOBS_VL JOB,
346: HR_LOCATIONS_ALL LOC
347: WHERE PEO.PERSON_ID = ASS.PERSON_ID
348: AND PEO.PER_INFORMATION1 is not null

Line 369: PER_ASSIGNMENTS_F ASS1

365: AND ASS.EFFECTIVE_START_DATE = (
366: SELECT
367: MAX(ASS1.EFFECTIVE_START_DATE)
368: FROM
369: PER_ASSIGNMENTS_F ASS1
370: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
371: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
372: AND ASS.PERSON_ID = ASS1.PERSON_ID
373: AND ASS1.ASSIGNMENT_TYPE = 'E'