APPS.PON_PRINTING_PKG dependencies on FND_USER

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 496: fnd_user.person_party_id = p_user_party_id

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)
499: FROM per_all_people_f per1
500: WHERE papf.person_id = per1.person_id)

Line 497: and fnd_user.employee_id = papf.person_id

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)
499: FROM per_all_people_f per1
500: WHERE papf.person_id = per1.person_id)
501: and rownum = 1;

Line 1704: ,fnd_user fuser

1700: ,pa_projects_all proj
1701: ,pa_tasks task
1702: ,gms_awards_all awrd
1703: ,hr_all_organization_units hrorg
1704: ,fnd_user fuser
1705: ,pon_bid_item_prices pbip
1706: where
1707: paip.auction_header_id = pah.auction_header_id
1708: and pbip.auction_header_id(+) = paip.auction_header_id

Line 1763: FND_USER U,

1759: p_server_time_zone,
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

Line 1813: ,fnd_user fuser

1809: stmem.team_id
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

Line 2406: fnd_user fuser,

2402: pa_tasks task,
2403: gms_awards_all awrd,
2404: hr_locations_all hrl,
2405: hr_all_organization_units hrorg,
2406: fnd_user fuser,
2407: po_lookup_codes lkp1,
2408: fnd_territories_tl terr,
2409: mtl_units_of_measure_tl uom_tl
2410: WHERE pay.auction_header_id = p_auction_header_id

Line 2482: fnd_user fuser,

2478: pa_tasks task,
2479: gms_awards_all awrd,
2480: hr_locations_all hrl,
2481: hr_all_organization_units hrorg,
2482: fnd_user fuser,
2483: po_lookup_codes lkp1,
2484: fnd_territories_tl terr,
2485: mtl_units_of_measure_tl uom_tl,
2486: pon_bid_payments_shipments pbp,

Line 3158: fnd_user buyer_user,

3154: pon_negotiation_styles_vl ns,
3155: PO_ALL_DOC_STYLE_LINES ps,
3156: po_doc_style_headers postyl,
3157: pa_projects_all proj,
3158: fnd_user buyer_user,
3159: per_phones buyer_phone,
3160: per_phones buyer_fax,
3161: pon_bid_headers pbhs,
3162: fnd_lookup_values fl_bid