APPS.PON_NEGOTIATION_COPY_GRP dependencies on PER_ALL_PEOPLE_F

Line 1639: PER_ALL_PEOPLE_F PER,

1635: FROM PER_ALL_ASSIGNMENTS_F ASS,
1636: PER_ALL_ASSIGNMENTS_F SUPASS,
1637: FND_USER SUP,
1638: FND_USER EMP,
1639: PER_ALL_PEOPLE_F PER,
1640: PER_ALL_POSITIONS POS
1641: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID
1642: AND ASS.SUPERVISOR_ID = SUP.EMPLOYEE_ID
1643: AND ASS.PRIMARY_FLAG = 'Y'

Line 7346: PER_ALL_PEOPLE_F P,

7342: l_last_notif_date,
7343: l_auc_business_group_id
7344: FROM PON_NEG_TEAM_MEMBERS PNTM,
7345: FND_USER U,
7346: PER_ALL_PEOPLE_F P,
7347: PER_ALL_ASSIGNMENTS_F A,
7348: PER_ALL_POSITIONS S,
7349: PON_AUCTION_HEADERS_ALL AH,
7350: FINANCIALS_SYSTEM_PARAMS_ALL F

Line 7358: FROM PER_ALL_PEOPLE_F PP

7354: AND NVL(F.ORG_ID, -9999) = NVL(AH.ORG_ID, -9999)
7355: AND P.PERSON_ID = U.EMPLOYEE_ID
7356: AND P.EFFECTIVE_END_DATE =
7357: (SELECT MAX(PP.EFFECTIVE_END_DATE)
7358: FROM PER_ALL_PEOPLE_F PP
7359: WHERE PP.PERSON_ID = U.EMPLOYEE_ID)
7360: AND A.PERSON_ID = P.PERSON_ID
7361: AND A.PRIMARY_FLAG = 'Y'
7362: AND ((A.ASSIGNMENT_TYPE = 'E' AND P.CURRENT_EMPLOYEE_FLAG = 'Y') OR

Line 7624: FND_USER U, PER_ALL_PEOPLE_F P

7620: INTO
7621: l_full_name
7622: FROM (SELECT PNTM.USER_ID, P.FULL_NAME
7623: FROM PON_NEG_TEAM_MEMBERS PNTM,
7624: FND_USER U, PER_ALL_PEOPLE_F P
7625: WHERE U.USER_ID = PNTM.USER_ID
7626: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
7627: AND PNTM.MEMBER_TYPE = 'N'
7628: AND P.PERSON_ID = U.EMPLOYEE_ID

Line 7632: FND_USER U, PER_ALL_PEOPLE_F P

7628: AND P.PERSON_ID = U.EMPLOYEE_ID
7629: MINUS
7630: SELECT PNTM.USER_ID, P.FULL_NAME
7631: FROM PON_NEG_TEAM_MEMBERS PNTM,
7632: FND_USER U, PER_ALL_PEOPLE_F P
7633: WHERE U.USER_ID = PNTM.USER_ID
7634: AND PNTM.AUCTION_HEADER_ID = p_auction_header_id
7635: AND P.PERSON_ID = U.EMPLOYEE_ID);
7636: