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.HXC_TIMECARD_UTILITIES dependencies on PER_ALL_ASSIGNMENTS_F

Line 1245: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

1241: IS
1242: l_assignment_index NUMBER;
1243: l_start_date DATE;
1244: l_end_date DATE;
1245: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1246: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1247: l_assignment_periods periods;
1248: l_assign_period_limit NUMBER; -- 5922228
1249:

Line 1246: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

1242: l_assignment_index NUMBER;
1243: l_start_date DATE;
1244: l_end_date DATE;
1245: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1246: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1247: l_assignment_periods periods;
1248: l_assign_period_limit NUMBER; -- 5922228
1249:
1250:

Line 1259: FROM PER_ALL_ASSIGNMENTS_F pas,

1255: IS
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'

Line 1364: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

1360: l_start_date DATE;
1361: l_end_date DATE;
1362: l_num_past_days NUMBER;
1363: l_num_future_days NUMBER;
1364: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1365: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1366: l_rec_period_id VARCHAR2(50);
1367:
1368: l_index BINARY_INTEGER;

Line 1365: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

1361: l_end_date DATE;
1362: l_num_past_days NUMBER;
1363: l_num_future_days NUMBER;
1364: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1365: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1366: l_rec_period_id VARCHAR2(50);
1367:
1368: l_index BINARY_INTEGER;
1369: l_pref_table hxc_preference_evaluation.t_pref_table;

Line 1379: FROM PER_ALL_ASSIGNMENTS_F pas,

1375: IS
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'