DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_PPA_INVOICE_DISTS_GT

Line 1338: FROM ap_ppa_invoice_dists_gt

1334:
1335: /* Modified below SELECT for bug#10416960
1336: SELECT invoice_distribution_id
1337: INTO l_dist_id
1338: FROM ap_ppa_invoice_dists_gt
1339: WHERE corrected_invoice_dist_id =
1340: (SELECT invoice_distribution_id --5485084
1341: FROM ap_invoice_distributions_all
1342: WHERE DECODE(p_match_type,

Line 1357: FROM ap_ppa_invoice_dists_gt

1353:
1354: BEGIN
1355: SELECT invoice_distribution_id
1356: INTO l_dist_id
1357: FROM ap_ppa_invoice_dists_gt
1358: WHERE DECODE(p_match_type,
1359: 'PRICE_CORRECTION',corrected_invoice_dist_id,
1360: 'ADJUSTMENT_CORRECTION',corrected_invoice_dist_id,
1361: related_id) = p_ccid