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 981: -- , FND_USER fu

977: and application_id = 396
978: and language_code = l_printing_language) as GENERIC_MESSAGES
979: FROM pon_auction_headers_all pah
980: , fnd_lookup_values flv
981: -- , FND_USER fu
982: WHERE pah.auction_header_id = p_auction_header_id --Using the variable p_auction_header_id
983: and flv.lookup_type(+) = 'PON_AUCTION_EMD_TYPE'
984: and flv.language(+) = USERENV('LANG')
985: and flv.lookup_code(+) = pah.EMD_TYPE;

Line 2579: fnd_user buyer_user,

2575: pon_negotiation_styles_vl ns,
2576: PO_ALL_DOC_STYLE_LINES ps,
2577: po_doc_style_headers postyl,
2578: pa_projects_all proj,
2579: fnd_user buyer_user,
2580: per_phones buyer_phone,
2581: per_phones buyer_fax,
2582: pon_bid_headers pbhs,
2583: fnd_lookup_values fl_bid

Line 2849: ,fnd_user fuser

2845: ,pa_projects_all proj
2846: ,pa_tasks_expend_v task
2847: ,gms_awards_all awrd
2848: ,hr_all_organization_units hrorg
2849: ,fnd_user fuser
2850: ,pon_bid_item_prices pbip
2851: where
2852: paip.auction_header_id = p_auction_header_id
2853: AND paip.line_number = line_num

Line 2965: fnd_user fuser,

2961: pa_tasks_expend_v task,
2962: gms_awards_all awrd,
2963: hr_locations_all hrl,
2964: hr_all_organization_units hrorg,
2965: fnd_user fuser,
2966: po_lookup_codes lkp1,
2967: fnd_territories_tl terr,
2968: mtl_units_of_measure_tl uom_tl
2969: WHERE pay.auction_header_id = p_auction_header_id

Line 3040: fnd_user fuser,

3036: pa_tasks_expend_v task,
3037: gms_awards_all awrd,
3038: hr_locations_all hrl,
3039: hr_all_organization_units hrorg,
3040: fnd_user fuser,
3041: po_lookup_codes lkp1,
3042: fnd_territories_tl terr,
3043: mtl_units_of_measure_tl uom_tl,
3044: pon_bid_payments_shipments pbp,

Line 3523: FND_USER U,

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

Line 3611: ,fnd_user fuser

3607: ,stmem.user_id
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