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 2651: and buyer_phone.parent_table(+) = 'PER_ALL_PEOPLE_F'

2647: and pah.po_style_id = ps.style_id(+)
2648: and pah.contract_type = ps.document_subtype(+)
2649: and ps.language(+) = l_printing_language
2650: and pah.trading_partner_contact_name = buyer_user.user_name
2651: and buyer_phone.parent_table(+) = 'PER_ALL_PEOPLE_F'
2652: and buyer_phone.parent_id(+) = buyer_user.employee_id
2653: and buyer_phone.phone_type(+) = 'W1'
2654: and nvl(buyer_phone.date_from(+), trunc(sysdate)) <= trunc(sysdate)
2655: and nvl(buyer_phone.date_to(+), trunc(sysdate)) >= trunc(sysdate)

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

2652: and buyer_phone.parent_id(+) = buyer_user.employee_id
2653: and buyer_phone.phone_type(+) = 'W1'
2654: and nvl(buyer_phone.date_from(+), trunc(sysdate)) <= trunc(sysdate)
2655: and nvl(buyer_phone.date_to(+), trunc(sysdate)) >= trunc(sysdate)
2656: and buyer_fax.parent_table(+) = 'PER_ALL_PEOPLE_F'
2657: and buyer_fax.parent_id(+) = buyer_user.employee_id
2658: and buyer_fax.phone_type(+) = 'WF'
2659: and nvl(buyer_fax.date_from(+), trunc(sysdate)) <= trunc(sysdate)
2660: and nvl(buyer_fax.date_to(+), trunc(sysdate)) >= trunc(sysdate)

Line 2828: FROM per_all_people_f per

2824: ,hrorg.name project_exp_organization_name
2825: ,pon_oa_util_pkg.display_date(paip.project_expenditure_item_date, p_client_time_zone,
2826: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
2827: ,NVL2(paip.work_approver_user_id, (SELECT per.full_name
2828: FROM per_all_people_f per
2829: WHERE per.person_id = fuser.employee_id
2830: AND per.effective_end_date =
2831: (SELECT MAX(per1.effective_end_date)
2832: FROM per_all_people_f per1

Line 2832: FROM per_all_people_f per1

2828: FROM per_all_people_f per
2829: WHERE per.person_id = fuser.employee_id
2830: AND per.effective_end_date =
2831: (SELECT MAX(per1.effective_end_date)
2832: FROM per_all_people_f per1
2833: WHERE per.person_id = per1.person_id)
2834: ), NULL) work_approver_name
2835: ,paip.has_quantity_tiers negline_has_quantity_tiers
2836: ,pbip.has_quantity_tiers bidline_has_quantity_tiers

Line 2935: FROM per_all_people_f per

2931: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2932: ,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
2933: ,pay.work_approver_user_id
2934: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2935: FROM per_all_people_f per
2936: WHERE per.person_id = fuser.employee_id
2937: AND per.effective_end_date =
2938: (SELECT MAX(per1.effective_end_date)
2939: FROM per_all_people_f per1

Line 2939: FROM per_all_people_f per1

2935: FROM per_all_people_f per
2936: WHERE per.person_id = fuser.employee_id
2937: AND per.effective_end_date =
2938: (SELECT MAX(per1.effective_end_date)
2939: FROM per_all_people_f per1
2940: WHERE per.person_id = per1.person_id)
2941: ), NULL) work_approver_name
2942: ,pay.note_to_bidders
2943: ,pay.project_id project_id

Line 3011: FROM per_all_people_f per

3007: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
3008: ,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
3009: ,pay.work_approver_user_id
3010: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
3011: FROM per_all_people_f per
3012: WHERE per.person_id = fuser.employee_id
3013: AND per.effective_end_date =
3014: (SELECT MAX(per1.effective_end_date)
3015: FROM per_all_people_f per1

Line 3015: FROM per_all_people_f per1

3011: FROM per_all_people_f per
3012: WHERE per.person_id = fuser.employee_id
3013: AND per.effective_end_date =
3014: (SELECT MAX(per1.effective_end_date)
3015: FROM per_all_people_f per1
3016: WHERE per.person_id = per1.person_id)
3017: ), NULL) work_approver_name
3018: ,pay.note_to_bidders
3019: ,pay.project_id project_id

Line 3524: PER_ALL_PEOPLE_F P,

3520: FROM
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

Line 3539: FROM PER_ALL_PEOPLE_F PP

3535: AND U.USER_ID = TM.USER_ID
3536: AND U.EMPLOYEE_ID = P.PERSON_ID
3537: AND P.EFFECTIVE_END_DATE =
3538: (SELECT MAX(PP.EFFECTIVE_END_DATE)
3539: FROM PER_ALL_PEOPLE_F PP
3540: WHERE PP.PERSON_ID = U.EMPLOYEE_ID)
3541: AND A.PERSON_ID = P.PERSON_ID
3542: AND A.PRIMARY_FLAG = 'Y'
3543: AND ((A.ASSIGNMENT_TYPE = 'E' AND P.CURRENT_EMPLOYEE_FLAG = 'Y')

Line 3612: ,per_all_people_f per

3608: ,per.full_name member_name
3609: FROM pon_auction_headers_all pah
3610: ,pon_scoring_team_members stmem
3611: ,fnd_user fuser
3612: ,per_all_people_f per
3613: WHERE pah.auction_header_id = p_auction_header_id
3614: AND stmem.auction_header_id = pah.auction_header_id
3615: AND stmem.user_id = fuser.user_id
3616: AND fuser.employee_id = per.person_id

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

3614: AND stmem.auction_header_id = pah.auction_header_id
3615: AND stmem.user_id = fuser.user_id
3616: AND fuser.employee_id = per.person_id
3617: AND pah.has_scoring_teams_flag = 'Y' -- members present only if teams present
3618: AND per.effective_end_date = (select max(pp.effective_end_date) from per_all_people_f pp where pp.person_id = per.person_id);
3619:
3620: BEGIN
3621: queryCtx := DBMS_XMLGEN.newContext(scoring_mems_cursor);
3622: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'SCORING_TEAM_MEMBERS');