DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 3525: PER_ALL_ASSIGNMENTS_F A,

3521: PON_AUCTION_HEADERS_ALL PAH,
3522: PON_NEG_TEAM_MEMBERS TM,
3523: FND_USER U,
3524: PER_ALL_PEOPLE_F P,
3525: PER_ALL_ASSIGNMENTS_F A,
3526: PER_ALL_POSITIONS S,
3527: FND_LOOKUPS flkp
3528: WHERE PAH.auction_header_id = p_auction_header_id
3529: AND TM.AUCTION_HEADER_ID = pah.auction_header_id

Line 3548: FROM PER_ALL_ASSIGNMENTS_F AA

3544: OR
3545: (A.ASSIGNMENT_TYPE = 'C' AND P.CURRENT_NPW_FLAG = 'Y'))
3546: AND A.EFFECTIVE_END_DATE =
3547: (SELECT MAX(AA.EFFECTIVE_END_DATE)
3548: FROM PER_ALL_ASSIGNMENTS_F AA
3549: WHERE AA.PRIMARY_FLAG = 'Y'
3550: AND AA.ASSIGNMENT_TYPE in ('E', 'C')
3551: AND AA.PERSON_ID = P.PERSON_ID)
3552: AND A.POSITION_ID = S.POSITION_ID(+)