[Home] [Help]
1269: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
1270: l_business_group_id PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE;
1271: l_effective_start_date PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;
1272: l_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;
1273: l_position PER_ALL_POSITIONS.name%TYPE;
1274: l_user_name fnd_user.USER_NAME%TYPE;
1275: l_user_id fnd_user.USER_ID%TYPE;
1276: l_employee_id fnd_user.EMPLOYEE_ID%TYPE;
1277: l_user_start_date fnd_user.START_DATE%TYPE;
1284: lm_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
1285: lm_business_group_id PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE;
1286: lm_effective_start_date PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;
1287: lm_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;
1288: lm_position PER_ALL_POSITIONS.name%TYPE;
1289: lm_user_name fnd_user.USER_NAME%TYPE;
1290: lm_user_id fnd_user.USER_ID%TYPE;
1291: lm_employee_id fnd_user.EMPLOYEE_ID%TYPE;
1292: lm_user_start_date fnd_user.START_DATE%TYPE;
1313: l_employee_id
1314: FROM PER_ALL_ASSIGNMENTS_F ASS,
1315: FND_USER EMP ,
1316: PER_ALL_PEOPLE_F PER ,
1317: PER_ALL_POSITIONS POS ,
1318: PON_AUCTION_HEADERS_ALL PAH ,
1319: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1320: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID
1321: AND ASS.POSITION_ID = POS.POSITION_ID(+)
1368: PER_ALL_ASSIGNMENTS_F SUPASS ,
1369: FND_USER SUP ,
1370: FND_USER EMP ,
1371: PER_ALL_PEOPLE_F PER ,
1372: PER_ALL_POSITIONS POS
1373: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID
1374: AND ASS.SUPERVISOR_ID = SUP.EMPLOYEE_ID
1375: AND ASS.PRIMARY_FLAG = 'Y'
1376: AND ASS.ASSIGNMENT_TYPE IN ('E', 'C')
7150: PER_ALL_ASSIGNMENTS_F SUPASS ,
7151: FND_USER SUP ,
7152: FND_USER EMP ,
7153: PER_ALL_PEOPLE_F PER ,
7154: PER_ALL_POSITIONS POS
7155: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID
7156: AND ASS.SUPERVISOR_ID = SUP.EMPLOYEE_ID
7157: AND ASS.PRIMARY_FLAG = 'Y'
7158: AND ASS.ASSIGNMENT_TYPE IN ('E', 'C')