APPS.ZX_PO_REC_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 24: TYPE get_rec_rate_tbl1 IS TABLE OF PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;

20:
21:
22: -- pg_get_tax_recovery_rate_tab get_rec_rate_tbl;
23: l_rec_rate number;
24: TYPE get_rec_rate_tbl1 IS TABLE OF PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;
25: pg_get_tax_recovery_rate_tab1 get_rec_rate_tbl1;
26:
27: C_LINES_PER_INSERT CONSTANT NUMBER := 5000;
28: i NUMBER;

Line 72: po_distributions_all pod,

68: trunc(poh.last_update_date) >= upd.start_date
69: )
70: AND lgr.ledger_id = fsp.set_of_books_id
71: ) poh,
72: po_distributions_all pod,
73: po_line_locations_all poll,
74: po_lines_all pol,
75: ap_tax_codes_all atc,
76: ar_tax_group_codes_all atg,

Line 283: po_distributions_all pod,

279: atc1.tax_recovery_rule_id,
280: atc1.tax_recovery_rate,
281: pov.vendor_type_lookup_code
282: FROM po_headers_all poh,
283: po_distributions_all pod,
284: po_line_locations_all poll,
285: po_lines_all pol,
286: ap_tax_codes_all atc,
287: ar_tax_group_codes_all atg,

Line 330: po_distributions_all pod,

326: atc1.tax_recovery_rule_id,
327: atc1.tax_recovery_rate,
328: pov.vendor_type_lookup_code
329: FROM po_line_locations_all poll,
330: po_distributions_all pod,
331: po_headers_all poh,
332: po_lines_all pol,
333: ap_tax_codes_all atc,
334: ar_tax_group_codes_all atg,

Line 559: po_distributions_all pod,

555: and other_doc_entity_code = 'PURCHASE_ORDER'
556: and other_doc_event_class_code = 'PO_PA'
557: ) zxvalerr,
558: po_headers_all poh,
559: po_distributions_all pod,
560: po_line_locations_all poll,
561: po_lines_all pol,
562: ap_tax_codes_all atc,
563: ar_tax_group_codes_all atg,

Line 612: po_distributions_all pod,

608: and other_doc_event_class_code = 'RELEASE'
609: ) zxvalerr,
610: po_line_locations_all poll,
611: po_headers_all poh,
612: po_distributions_all pod,
613: po_lines_all pol,
614: ap_tax_codes_all atc,
615: ar_tax_group_codes_all atg,
616: ap_tax_codes_all atc1,