APPS.PON_NEGOTIATION_COPY_GRP dependencies on PER_ALL_PEOPLE_F

Line 6200: PER_ALL_PEOPLE_F P,

6196: l_last_notif_date,
6197: l_auc_business_group_id
6198: FROM PON_NEG_TEAM_MEMBERS PNTM,
6199: FND_USER U,
6200: PER_ALL_PEOPLE_F P,
6201: PER_ALL_ASSIGNMENTS_F A,
6202: PER_ALL_POSITIONS S,
6203: PON_AUCTION_HEADERS_ALL AH,
6204: FINANCIALS_SYSTEM_PARAMS_ALL F

Line 6212: FROM PER_ALL_PEOPLE_F PP

6208: AND NVL(F.ORG_ID, -9999) = NVL(AH.ORG_ID, -9999)
6209: AND P.PERSON_ID = U.EMPLOYEE_ID
6210: AND P.EFFECTIVE_END_DATE =
6211: (SELECT MAX(PP.EFFECTIVE_END_DATE)
6212: FROM PER_ALL_PEOPLE_F PP
6213: WHERE PP.PERSON_ID = U.EMPLOYEE_ID)
6214: AND A.PERSON_ID = P.PERSON_ID
6215: AND A.PRIMARY_FLAG = 'Y'
6216: AND ((A.ASSIGNMENT_TYPE = 'E' AND P.CURRENT_EMPLOYEE_FLAG = 'Y') OR

Line 6468: FND_USER U, PER_ALL_PEOPLE_F P

6464: INTO
6465: l_full_name
6466: FROM (SELECT PNTM.USER_ID, P.FULL_NAME
6467: FROM PON_NEG_TEAM_MEMBERS PNTM,
6468: FND_USER U, PER_ALL_PEOPLE_F P
6469: WHERE U.USER_ID = PNTM.USER_ID
6470: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
6471: AND PNTM.MEMBER_TYPE = 'N'
6472: AND P.PERSON_ID = U.EMPLOYEE_ID

Line 6476: FND_USER U, PER_ALL_PEOPLE_F P

6472: AND P.PERSON_ID = U.EMPLOYEE_ID
6473: MINUS
6474: SELECT PNTM.USER_ID, P.FULL_NAME
6475: FROM PON_NEG_TEAM_MEMBERS PNTM,
6476: FND_USER U, PER_ALL_PEOPLE_F P
6477: WHERE U.USER_ID = PNTM.USER_ID
6478: AND PNTM.AUCTION_HEADER_ID = p_auction_header_id
6479: AND P.PERSON_ID = U.EMPLOYEE_ID);
6480: