DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on HR_LOCATIONS

Line 19: location_code hr_locations.location_code%TYPE,

15: invoice_num ap_expense_report_headers.invoice_num%TYPE,
16: total ap_expense_report_headers.total%TYPE,
17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,

Line 20: address_line_1 hr_locations.address_line_1%TYPE,

16: total ap_expense_report_headers.total%TYPE,
17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,

Line 21: address_line_2 hr_locations.address_line_2%TYPE,

17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,

Line 22: address_line_3 hr_locations.address_line_3%TYPE,

18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,

Line 23: city hr_locations.town_or_city%TYPE,

19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,

Line 24: state hr_locations.region_2%TYPE,

20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,

Line 25: postal_code hr_locations.postal_code%TYPE,

21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,

Line 26: province hr_locations.region_1%TYPE,

22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,

Line 27: county hr_locations.region_1%TYPE,

23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,

Line 28: country hr_locations.country%TYPE,

24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,
32: --nls_hold_code ap_lookup_codes.displayed_field%TYPE,

Line 105: style hr_locations.style%TYPE,

101: per_information18_19 per_all_people_f.per_information18%TYPE,
102: per_information_category per_all_people_f.per_information_category%TYPE,
103: source ap_expense_report_headers.source%TYPE,
104: group_id ap_invoices_interface.group_id%TYPE,
105: style hr_locations.style%TYPE,
106: org_id ap_expense_report_headers_all.org_id%TYPE,
107: invoice_id ap_invoices_interface.invoice_id%TYPE,
108: invoice_type_lookup_code ap_invoices_interface.invoice_type_lookup_code%TYPE,
109: gl_date ap_invoices_interface.gl_date%TYPE,

Line 240: address_line_1 hr_locations.address_line_1%TYPE,

236: vendor_name ap_suppliers.vendor_name%TYPE,
237: vendor_num ap_suppliers.segment1%TYPE,
238: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
239: org_id ap_expense_report_headers.org_id%TYPE,
240: address_line_1 hr_locations.address_line_1%TYPE,
241: address_line_2 hr_locations.address_line_2%TYPE,
242: address_line_3 hr_locations.address_line_3%TYPE,
243: city hr_locations.town_or_city%TYPE,
244: state hr_locations.region_2%TYPE,

Line 241: address_line_2 hr_locations.address_line_2%TYPE,

237: vendor_num ap_suppliers.segment1%TYPE,
238: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
239: org_id ap_expense_report_headers.org_id%TYPE,
240: address_line_1 hr_locations.address_line_1%TYPE,
241: address_line_2 hr_locations.address_line_2%TYPE,
242: address_line_3 hr_locations.address_line_3%TYPE,
243: city hr_locations.town_or_city%TYPE,
244: state hr_locations.region_2%TYPE,
245: postal_code hr_locations.postal_code%TYPE,

Line 242: address_line_3 hr_locations.address_line_3%TYPE,

238: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
239: org_id ap_expense_report_headers.org_id%TYPE,
240: address_line_1 hr_locations.address_line_1%TYPE,
241: address_line_2 hr_locations.address_line_2%TYPE,
242: address_line_3 hr_locations.address_line_3%TYPE,
243: city hr_locations.town_or_city%TYPE,
244: state hr_locations.region_2%TYPE,
245: postal_code hr_locations.postal_code%TYPE,
246: province hr_locations.region_1%TYPE,

Line 243: city hr_locations.town_or_city%TYPE,

239: org_id ap_expense_report_headers.org_id%TYPE,
240: address_line_1 hr_locations.address_line_1%TYPE,
241: address_line_2 hr_locations.address_line_2%TYPE,
242: address_line_3 hr_locations.address_line_3%TYPE,
243: city hr_locations.town_or_city%TYPE,
244: state hr_locations.region_2%TYPE,
245: postal_code hr_locations.postal_code%TYPE,
246: province hr_locations.region_1%TYPE,
247: county hr_locations.region_1%TYPE,

Line 244: state hr_locations.region_2%TYPE,

240: address_line_1 hr_locations.address_line_1%TYPE,
241: address_line_2 hr_locations.address_line_2%TYPE,
242: address_line_3 hr_locations.address_line_3%TYPE,
243: city hr_locations.town_or_city%TYPE,
244: state hr_locations.region_2%TYPE,
245: postal_code hr_locations.postal_code%TYPE,
246: province hr_locations.region_1%TYPE,
247: county hr_locations.region_1%TYPE,
248: country hr_locations.country%TYPE,

Line 245: postal_code hr_locations.postal_code%TYPE,

241: address_line_2 hr_locations.address_line_2%TYPE,
242: address_line_3 hr_locations.address_line_3%TYPE,
243: city hr_locations.town_or_city%TYPE,
244: state hr_locations.region_2%TYPE,
245: postal_code hr_locations.postal_code%TYPE,
246: province hr_locations.region_1%TYPE,
247: county hr_locations.region_1%TYPE,
248: country hr_locations.country%TYPE,
249: style hr_locations.style%TYPE);

Line 246: province hr_locations.region_1%TYPE,

242: address_line_3 hr_locations.address_line_3%TYPE,
243: city hr_locations.town_or_city%TYPE,
244: state hr_locations.region_2%TYPE,
245: postal_code hr_locations.postal_code%TYPE,
246: province hr_locations.region_1%TYPE,
247: county hr_locations.region_1%TYPE,
248: country hr_locations.country%TYPE,
249: style hr_locations.style%TYPE);
250:

Line 247: county hr_locations.region_1%TYPE,

243: city hr_locations.town_or_city%TYPE,
244: state hr_locations.region_2%TYPE,
245: postal_code hr_locations.postal_code%TYPE,
246: province hr_locations.region_1%TYPE,
247: county hr_locations.region_1%TYPE,
248: country hr_locations.country%TYPE,
249: style hr_locations.style%TYPE);
250:
251: ------------------------------------------------------------------------

Line 248: country hr_locations.country%TYPE,

244: state hr_locations.region_2%TYPE,
245: postal_code hr_locations.postal_code%TYPE,
246: province hr_locations.region_1%TYPE,
247: county hr_locations.region_1%TYPE,
248: country hr_locations.country%TYPE,
249: style hr_locations.style%TYPE);
250:
251: ------------------------------------------------------------------------
252: PROCEDURE UpdateDistsWithReceiptInfo(p_report_header_id IN NUMBER,

Line 249: style hr_locations.style%TYPE);

245: postal_code hr_locations.postal_code%TYPE,
246: province hr_locations.region_1%TYPE,
247: county hr_locations.region_1%TYPE,
248: country hr_locations.country%TYPE,
249: style hr_locations.style%TYPE);
250:
251: ------------------------------------------------------------------------
252: PROCEDURE UpdateDistsWithReceiptInfo(p_report_header_id IN NUMBER,
253: p_debug_switch IN VARCHAR2);