DBA Data[Home] [Help]

APPS.PO_TAX_SV dependencies on PO_DISTRIBUTIONS_ALL

Line 24: FROM po_distributions_all

20:
21: IF x_calling_form = 'PO' OR x_calling_form = 'RELEASE' THEN
22: SELECT recoverable_tax, nonrecoverable_tax
23: INTO x_recoverable_tax, x_nonrecoverable_tax
24: FROM po_distributions_all
25: WHERE po_distribution_id = x_distribution_id;
26:
27: ELSIF x_calling_form = 'REQ' THEN
28: SELECT recoverable_tax, nonrecoverable_tax

Line 116: FROM po_distributions_all pd,

112: INTO x_recoverable_tax,
113: x_non_recoverable_tax,
114: x_old_recoverable_tax,
115: x_old_non_recoverable_tax
116: FROM po_distributions_all pd,
117: po_distributions_archive_all pda
118: WHERE pd.po_distribution_id = p_distribution_id
119: AND pd.po_distribution_id = pda.po_distribution_id (+)
120: AND pda.latest_external_flag (+) = 'Y';