DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTILITIES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1260: per_assignment_status_types typ

1256: SELECT pas.ASSIGNMENT_ID,
1257: pas.EFFECTIVE_START_DATE,
1258: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)
1259: FROM PER_ALL_ASSIGNMENTS_F pas,
1260: per_assignment_status_types typ
1261: WHERE pas.PERSON_ID = p_resource_id
1262: AND pas.ASSIGNMENT_TYPE in ('E','C')
1263: AND pas.PRIMARY_FLAG = 'Y'
1264: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID

Line 1380: per_assignment_status_types typ

1376: SELECT pas.ASSIGNMENT_ID,
1377: pas.EFFECTIVE_START_DATE,
1378: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)
1379: FROM PER_ALL_ASSIGNMENTS_F pas,
1380: per_assignment_status_types typ
1381: WHERE pas.PERSON_ID = p_resource_id
1382: AND pas.ASSIGNMENT_TYPE = 'E'
1383: AND pas.PRIMARY_FLAG = 'Y'
1384: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID