eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_OFFERS_API dependencies on PER_ALL_PEOPLE_F

Line 1466: ,PER_ALL_PEOPLE_F per

1462: CURSOR csr_other_extended_offers IS
1463: SELECT count(otheroffer.offer_id)
1464: FROM IRC_OFFERS otheroffer
1465: ,PER_ALL_ASSIGNMENTS_F otherasg
1466: ,PER_ALL_PEOPLE_F per
1467: ,PER_ALL_PEOPLE_F linkper
1468: ,IRC_OFFER_STATUS_HISTORY otherhistory
1469: WHERE (
1470: -- Other Extended Offers

Line 1467: ,PER_ALL_PEOPLE_F linkper

1463: SELECT count(otheroffer.offer_id)
1464: FROM IRC_OFFERS otheroffer
1465: ,PER_ALL_ASSIGNMENTS_F otherasg
1466: ,PER_ALL_PEOPLE_F per
1467: ,PER_ALL_PEOPLE_F linkper
1468: ,IRC_OFFER_STATUS_HISTORY otherhistory
1469: WHERE (
1470: -- Other Extended Offers
1471: otheroffer.offer_status = 'EXTENDED'

Line 3671: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,

3667: ,p_effective_date IN DATE
3668: )
3669: IS
3670: select user_id
3671: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,
3672: per_all_people_f linkppf
3673: where p_effective_date between paf.effective_start_date and
3674: paf.effective_end_date
3675: and p_effective_date between usr.start_date and

Line 3672: per_all_people_f linkppf

3668: )
3669: IS
3670: select user_id
3671: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,
3672: per_all_people_f linkppf
3673: where p_effective_date between paf.effective_start_date and
3674: paf.effective_end_date
3675: and p_effective_date between usr.start_date and
3676: nvl(usr.end_date,p_effective_date)