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: 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 279: po_distributions_all pod,

275: atc1.tax_recovery_rule_id,
276: atc1.tax_recovery_rate,
277: pov.vendor_type_lookup_code
278: FROM po_headers_all poh,
279: po_distributions_all pod,
280: po_line_locations_all poll,
281: po_lines_all pol,
282: ap_tax_codes_all atc,
283: ar_tax_group_codes_all atg,

Line 326: po_distributions_all pod,

322: atc1.tax_recovery_rule_id,
323: atc1.tax_recovery_rate,
324: pov.vendor_type_lookup_code
325: FROM po_line_locations_all poll,
326: po_distributions_all pod,
327: po_headers_all poh,
328: po_lines_all pol,
329: ap_tax_codes_all atc,
330: ar_tax_group_codes_all atg,

Line 555: po_distributions_all pod,

551: and other_doc_entity_code = 'PURCHASE_ORDER'
552: and other_doc_event_class_code = 'PO_PA'
553: ) zxvalerr,
554: po_headers_all poh,
555: po_distributions_all pod,
556: po_line_locations_all poll,
557: po_lines_all pol,
558: ap_tax_codes_all atc,
559: ar_tax_group_codes_all atg,

Line 608: po_distributions_all pod,

604: and other_doc_event_class_code = 'RELEASE'
605: ) zxvalerr,
606: po_line_locations_all poll,
607: po_headers_all poh,
608: po_distributions_all pod,
609: po_lines_all pol,
610: ap_tax_codes_all atc,
611: ar_tax_group_codes_all atg,
612: ap_tax_codes_all atc1,