DBA Data[Home] [Help]

APPS.AP_IAW_PKG dependencies on FND_USER

Line 1957: fnd_user u

1953: FROM
1954: ap_invoices_all AI,
1955: po_vendors PV,
1956: po_vendor_sites_all PVS,
1957: fnd_user u
1958: WHERE
1959: AI.invoice_id = l_invoice_id AND
1960: AI.vendor_id = PV.vendor_id AND
1961: AI.vendor_site_id = PVS.vendor_site_id(+) and

Line 3975: l_ext_user_name fnd_user.user_name%TYPE;

3971: l_invoice_iteration ap_apinv_approvers.invoice_iteration%TYPE;
3972: l_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
3973: l_internal_contact_email ap_invoices_all.internal_contact_email%TYPE;
3974: l_source ap_invoices_all.source%TYPE;
3975: l_ext_user_name fnd_user.user_name%TYPE;
3976: l_adhoc_role_name wf_local_roles.name%TYPE;
3977: l_adhoc_display_name wf_local_roles.display_name%TYPE;
3978: l_fallback_role_name wf_local_roles.name%TYPE;
3979: -- l_line_appr_rec rLineApproverMappings;

Line 4092: fnd_user u

4088: ai.source, u.user_name
4089: into l_invoice_type, l_internal_contact_email,
4090: l_source, l_ext_user_name
4091: from ap_invoices_all ai,
4092: fnd_user u
4093: where invoice_id = l_invoice_id
4094: and u.user_id = ai.created_by
4095: and trunc(sysdate) between trunc(u.start_date)
4096: and trunc(nvl(u.end_date, sysdate+1));

Line 4293: fnd_user u

4289: cursor internal_reps is
4290: select distinct il.line_owner_role, i.source, u.user_name
4291: from ap_invoice_lines_all il,
4292: ap_invoices_all i,
4293: fnd_user u
4294: where il.line_owner_role is not null
4295: and il.line_type_lookup_code = 'ITEM'
4296: and i.invoice_id = l_invoice_id
4297: and i.org_id = l_org_id