DBA Data[Home] [Help]

APPS.IRC_OFFERS_API dependencies on PER_ALL_PEOPLE_F

Line 1370: ,PER_ALL_PEOPLE_F per

1366: CURSOR csr_other_extended_offers IS
1367: SELECT count(otheroffer.offer_id)
1368: FROM IRC_OFFERS otheroffer
1369: ,PER_ALL_ASSIGNMENTS_F otherasg
1370: ,PER_ALL_PEOPLE_F per
1371: ,PER_ALL_PEOPLE_F linkper
1372: ,IRC_OFFER_STATUS_HISTORY otherhistory
1373: WHERE (
1374: -- Other Extended Offers

Line 1371: ,PER_ALL_PEOPLE_F linkper

1367: SELECT count(otheroffer.offer_id)
1368: FROM IRC_OFFERS otheroffer
1369: ,PER_ALL_ASSIGNMENTS_F otherasg
1370: ,PER_ALL_PEOPLE_F per
1371: ,PER_ALL_PEOPLE_F linkper
1372: ,IRC_OFFER_STATUS_HISTORY otherhistory
1373: WHERE (
1374: -- Other Extended Offers
1375: otheroffer.offer_status = 'EXTENDED'