APPS.PON_NEGOTIATION_COPY_GRP dependencies on PER_ALL_ASSIGNMENTS_F

Line 1635: FROM PER_ALL_ASSIGNMENTS_F ASS,

1631: BEGIN
1632: SELECT
1633: SUP.USER_ID USER_ID
1634: INTO l_mgr_id
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,

Line 1636: PER_ALL_ASSIGNMENTS_F SUPASS,

1632: SELECT
1633: SUP.USER_ID USER_ID
1634: INTO l_mgr_id
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

Line 7347: PER_ALL_ASSIGNMENTS_F A,

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

Line 7366: FROM PER_ALL_ASSIGNMENTS_F AA

7362: AND ((A.ASSIGNMENT_TYPE = 'E' AND P.CURRENT_EMPLOYEE_FLAG = 'Y') OR
7363: (A.ASSIGNMENT_TYPE = 'C' AND P.CURRENT_NPW_FLAG = 'Y'))
7364: AND A.EFFECTIVE_END_DATE =
7365: (SELECT MAX(AA.EFFECTIVE_END_DATE)
7366: FROM PER_ALL_ASSIGNMENTS_F AA
7367: WHERE AA.PRIMARY_FLAG = 'Y'
7368: AND AA.ASSIGNMENT_TYPE in ('E', 'C')
7369: AND AA.PERSON_ID = P.PERSON_ID)
7370: AND A.POSITION_ID = S.POSITION_ID(+)