APPS.PON_NEGOTIATION_COPY_GRP dependencies on PER_ALL_ASSIGNMENTS_F

Line 6201: PER_ALL_ASSIGNMENTS_F A,

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
6205: WHERE U.USER_ID = PNTM.USER_ID

Line 6220: FROM PER_ALL_ASSIGNMENTS_F AA

6216: AND ((A.ASSIGNMENT_TYPE = 'E' AND P.CURRENT_EMPLOYEE_FLAG = 'Y') OR
6217: (A.ASSIGNMENT_TYPE = 'C' AND P.CURRENT_NPW_FLAG = 'Y'))
6218: AND A.EFFECTIVE_END_DATE =
6219: (SELECT MAX(AA.EFFECTIVE_END_DATE)
6220: FROM PER_ALL_ASSIGNMENTS_F AA
6221: WHERE AA.PRIMARY_FLAG = 'Y'
6222: AND AA.ASSIGNMENT_TYPE in ('E', 'C')
6223: AND AA.PERSON_ID = P.PERSON_ID)
6224: AND A.POSITION_ID = S.POSITION_ID(+)