APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_DISTRIBUTIONS_ALL

Line 1195: WHERE EXISTS (SELECT 'Y' FROM pn_distributions_all

1191: IS
1192: CURSOR has_distributions IS
1193: SELECT 'Y'
1194: FROM dual
1195: WHERE EXISTS (SELECT 'Y' FROM pn_distributions_all
1196: WHERE payment_term_id = x_payment_term_id);
1197:
1198: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
1199: l_org_id pn_payment_terms.org_id%TYPE;

Line 1905: FROM pn_distributions_all

1901: WHERE payment_term_id = p_term_id;
1902:
1903: CURSOR get_dist_cur(p_term_id IN NUMBER) IS
1904: SELECT *
1905: FROM pn_distributions_all
1906: WHERE payment_term_id = p_term_id;
1907:
1908: CURSOR get_max_dist_change_id_cur(p_term_id IN NUMBER) IS
1909: SELECT MAX(pdh.distribution_change_id)

Line 1911: pn_distributions_all pd

1907:
1908: CURSOR get_max_dist_change_id_cur(p_term_id IN NUMBER) IS
1909: SELECT MAX(pdh.distribution_change_id)
1910: FROM pn_distributions_history pdh,
1911: pn_distributions_all pd
1912: WHERE pdh.distribution_id = pd.distribution_id
1913: AND pd.payment_term_id = p_term_id;
1914:
1915: CURSOR get_max_term_hist_id_cur(p_term_id IN NUMBER) IS

Line 2665: UPDATE pn_distributions_all

2661: FROM DUAL;
2662:
2663: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_dist_id : '||l_new_dist_id);
2664:
2665: UPDATE pn_distributions_all
2666: SET distribution_id = l_new_dist_id,
2667: payment_term_id = l_new_term_id
2668: WHERE distribution_id = dist_rec.distribution_id;
2669:

Line 3264: INSERT INTO pn_distributions_all

3260: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);
3261: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);
3262: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');
3263:
3264: INSERT INTO pn_distributions_all
3265: (distribution_id
3266: ,account_id
3267: ,payment_term_id
3268: ,term_template_id