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.

[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on PER_ALL_PEOPLE_F

Line 1267: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;

1263: target_date IN DATE,
1264: manager_approver_flag IN VARCHAR2,
1265: x_return_status IN OUT NOCOPY VARCHAR2 )
1266: IS
1267: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1268: l_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;
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;

Line 1268: l_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;

1264: manager_approver_flag IN VARCHAR2,
1265: x_return_status IN OUT NOCOPY VARCHAR2 )
1266: IS
1267: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1268: l_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;
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;

Line 1269: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;

1265: x_return_status IN OUT NOCOPY VARCHAR2 )
1266: IS
1267: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1268: l_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;
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;

Line 1270: l_business_group_id PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE;

1266: IS
1267: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1268: l_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;
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;

Line 1271: l_effective_start_date PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;

1267: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1268: l_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;
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;

Line 1272: l_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;

1268: l_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;
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;

Line 1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;

1278: l_user_end_date fnd_user.END_DATE%TYPE;
1279: l_menu_name PON_NEG_TEAM_MEMBERS.menu_name%TYPE;
1280: l_member_type PON_NEG_TEAM_MEMBERS.member_type%TYPE;
1281: l_approver_flag PON_NEG_TEAM_MEMBERS.approver_flag%TYPE;
1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%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;

Line 1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;

1279: l_menu_name PON_NEG_TEAM_MEMBERS.menu_name%TYPE;
1280: l_member_type PON_NEG_TEAM_MEMBERS.member_type%TYPE;
1281: l_approver_flag PON_NEG_TEAM_MEMBERS.approver_flag%TYPE;
1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%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;

Line 1284: lm_person_id PER_ALL_PEOPLE_F.person_id%TYPE;

1280: l_member_type PON_NEG_TEAM_MEMBERS.member_type%TYPE;
1281: l_approver_flag PON_NEG_TEAM_MEMBERS.approver_flag%TYPE;
1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%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;

Line 1285: lm_business_group_id PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE;

1281: l_approver_flag PON_NEG_TEAM_MEMBERS.approver_flag%TYPE;
1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%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;

Line 1286: lm_effective_start_date PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;

1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%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;

Line 1287: lm_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;

1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%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;

Line 1316: PER_ALL_PEOPLE_F PER ,

1312: l_user_id ,
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

Line 1371: PER_ALL_PEOPLE_F PER ,

1367: FROM PER_ALL_ASSIGNMENTS_F ASS,
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'

Line 7153: PER_ALL_PEOPLE_F PER ,

7149: FROM PER_ALL_ASSIGNMENTS_F ASS,
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'