DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1765: PER_ALL_ASSIGNMENTS_F A,

1761: FROM
1762: PON_NEG_TEAM_MEMBERS TM,
1763: FND_USER U,
1764: PER_ALL_PEOPLE_F P,
1765: PER_ALL_ASSIGNMENTS_F A,
1766: PER_ALL_POSITIONS S,
1767: FND_LOOKUPS flkp
1768: WHERE
1769: TM.AUCTION_HEADER_ID = pah.auction_header_id

Line 1788: FROM PER_ALL_ASSIGNMENTS_F AA

1784: OR
1785: (A.ASSIGNMENT_TYPE = 'C' AND P.CURRENT_NPW_FLAG = 'Y'))
1786: AND A.EFFECTIVE_END_DATE =
1787: (SELECT MAX(AA.EFFECTIVE_END_DATE)
1788: FROM PER_ALL_ASSIGNMENTS_F AA
1789: WHERE AA.PRIMARY_FLAG = 'Y'
1790: AND AA.ASSIGNMENT_TYPE in ('E', 'C')
1791: AND AA.PERSON_ID = P.PERSON_ID)
1792: AND A.POSITION_ID = S.POSITION_ID(+)