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.PON_PRINTING_PKG dependencies on PER_ALL_PEOPLE_F

Line 485: x_usermail per_all_people_f.email_address%type;

481: -----------------------------------------------------------------
482: FUNCTION GET_USER_EMAIL(p_user_party_id in NUMBER)
483: return VARCHAR2 is
484:
485: x_usermail per_all_people_f.email_address%type;
486:
487: begin
488:
489:

Line 494: per_all_people_f papf, fnd_user

490: Select
491: papf.email_address into
492: x_usermail
493: from
494: per_all_people_f papf, fnd_user
495: where
496: fnd_user.person_party_id = p_user_party_id
497: and fnd_user.employee_id = papf.person_id
498: and papf.effective_end_date = (SELECT MAX(per1.effective_end_date)

Line 499: FROM per_all_people_f per1

495: where
496: fnd_user.person_party_id = p_user_party_id
497: and fnd_user.employee_id = papf.person_id
498: and papf.effective_end_date = (SELECT MAX(per1.effective_end_date)
499: FROM per_all_people_f per1
500: WHERE papf.person_id = per1.person_id)
501: and rownum = 1;
502:
503: return x_usermail;

Line 1683: FROM per_all_people_f per

1679: ,hrorg.name project_exp_organization_name
1680: ,pon_oa_util_pkg.display_date(paip.project_expenditure_item_date, p_client_time_zone,
1681: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
1682: ,NVL2(paip.work_approver_user_id, (SELECT per.full_name
1683: FROM per_all_people_f per
1684: WHERE per.person_id = fuser.employee_id
1685: AND per.effective_end_date =
1686: (SELECT MAX(per1.effective_end_date)
1687: FROM per_all_people_f per1

Line 1687: FROM per_all_people_f per1

1683: FROM per_all_people_f per
1684: WHERE per.person_id = fuser.employee_id
1685: AND per.effective_end_date =
1686: (SELECT MAX(per1.effective_end_date)
1687: FROM per_all_people_f per1
1688: WHERE per.person_id = per1.person_id)
1689: ), NULL) work_approver_name
1690: ,paip.has_quantity_tiers negline_has_quantity_tiers
1691: ,pbip.has_quantity_tiers bidline_has_quantity_tiers

Line 1764: PER_ALL_PEOPLE_F P,

1760: p_date_format, 'N') target_date
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

Line 1779: FROM PER_ALL_PEOPLE_F PP

1775: AND U.USER_ID = TM.USER_ID
1776: AND U.EMPLOYEE_ID = P.PERSON_ID
1777: AND P.EFFECTIVE_END_DATE =
1778: (SELECT MAX(PP.EFFECTIVE_END_DATE)
1779: FROM PER_ALL_PEOPLE_F PP
1780: WHERE PP.PERSON_ID = U.EMPLOYEE_ID)
1781: AND A.PERSON_ID = P.PERSON_ID
1782: AND A.PRIMARY_FLAG = 'Y'
1783: AND ((A.ASSIGNMENT_TYPE = 'E' AND P.CURRENT_EMPLOYEE_FLAG = 'Y')

Line 1814: ,per_all_people_f per

1810: ,stmem.user_id
1811: ,per.full_name member_name
1812: FROM pon_scoring_team_members stmem
1813: ,fnd_user fuser
1814: ,per_all_people_f per
1815: WHERE stmem.auction_header_id = pah.auction_header_id
1816: AND stmem.user_id = fuser.user_id
1817: AND fuser.employee_id = per.person_id
1818: AND pah.has_scoring_teams_flag = 'Y' -- members present only if teams present

Line 1819: AND per.effective_end_date = (select max(pp.effective_end_date) from per_all_people_f pp where pp.person_id = per.person_id)

1815: WHERE stmem.auction_header_id = pah.auction_header_id
1816: AND stmem.user_id = fuser.user_id
1817: AND fuser.employee_id = per.person_id
1818: AND pah.has_scoring_teams_flag = 'Y' -- members present only if teams present
1819: AND per.effective_end_date = (select max(pp.effective_end_date) from per_all_people_f pp where pp.person_id = per.person_id)
1820: ) AS SCORING_TEAM_MEMBERS,
1821: CURSOR (
1822: SELECT
1823: team_sections.section_id

Line 2376: FROM per_all_people_f per

2372: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2373: ,pon_oa_util_pkg.display_date_time(pay.need_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') need_by_date
2374: ,pay.work_approver_user_id
2375: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2376: FROM per_all_people_f per
2377: WHERE per.person_id = fuser.employee_id
2378: AND per.effective_end_date =
2379: (SELECT MAX(per1.effective_end_date)
2380: FROM per_all_people_f per1

Line 2380: FROM per_all_people_f per1

2376: FROM per_all_people_f per
2377: WHERE per.person_id = fuser.employee_id
2378: AND per.effective_end_date =
2379: (SELECT MAX(per1.effective_end_date)
2380: FROM per_all_people_f per1
2381: WHERE per.person_id = per1.person_id)
2382: ), NULL) work_approver_name
2383: ,pay.note_to_bidders
2384: ,pay.project_id project_id

Line 2453: FROM per_all_people_f per

2449: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2450: ,pon_oa_util_pkg.display_date_time(pay.need_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') need_by_date
2451: ,pay.work_approver_user_id
2452: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2453: FROM per_all_people_f per
2454: WHERE per.person_id = fuser.employee_id
2455: AND per.effective_end_date =
2456: (SELECT MAX(per1.effective_end_date)
2457: FROM per_all_people_f per1

Line 2457: FROM per_all_people_f per1

2453: FROM per_all_people_f per
2454: WHERE per.person_id = fuser.employee_id
2455: AND per.effective_end_date =
2456: (SELECT MAX(per1.effective_end_date)
2457: FROM per_all_people_f per1
2458: WHERE per.person_id = per1.person_id)
2459: ), NULL) work_approver_name
2460: ,pay.note_to_bidders
2461: ,pay.project_id project_id

Line 3229: and buyer_phone.parent_table(+) = 'PER_ALL_PEOPLE_F'

3225: and pah.po_style_id = ps.style_id(+)
3226: and pah.contract_type = ps.document_subtype(+)
3227: and ps.language(+) = l_printing_language
3228: and pah.trading_partner_contact_name = buyer_user.user_name
3229: and buyer_phone.parent_table(+) = 'PER_ALL_PEOPLE_F'
3230: and buyer_phone.parent_id(+) = buyer_user.employee_id
3231: and buyer_phone.phone_type(+) = 'W1'
3232: and nvl(buyer_phone.date_from(+), trunc(sysdate)) <= trunc(sysdate)
3233: and nvl(buyer_phone.date_to(+), trunc(sysdate)) >= trunc(sysdate)

Line 3234: and buyer_fax.parent_table(+) = 'PER_ALL_PEOPLE_F'

3230: and buyer_phone.parent_id(+) = buyer_user.employee_id
3231: and buyer_phone.phone_type(+) = 'W1'
3232: and nvl(buyer_phone.date_from(+), trunc(sysdate)) <= trunc(sysdate)
3233: and nvl(buyer_phone.date_to(+), trunc(sysdate)) >= trunc(sysdate)
3234: and buyer_fax.parent_table(+) = 'PER_ALL_PEOPLE_F'
3235: and buyer_fax.parent_id(+) = buyer_user.employee_id
3236: and buyer_fax.phone_type(+) = 'WF'
3237: and nvl(buyer_fax.date_from(+), trunc(sysdate)) <= trunc(sysdate)
3238: and nvl(buyer_fax.date_to(+), trunc(sysdate)) >= trunc(sysdate);