APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_DISTRIBUTIONS_ALL

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

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

Line 1909: FROM pn_distributions_all

1905: WHERE payment_term_id = p_term_id;
1906:
1907: CURSOR get_dist_cur(p_term_id IN NUMBER) IS
1908: SELECT *
1909: FROM pn_distributions_all
1910: WHERE payment_term_id = p_term_id;
1911:
1912: CURSOR get_max_dist_change_id_cur(p_term_id IN NUMBER) IS
1913: SELECT MAX(pdh.distribution_change_id)

Line 1915: pn_distributions_all pd

1911:
1912: CURSOR get_max_dist_change_id_cur(p_term_id IN NUMBER) IS
1913: SELECT MAX(pdh.distribution_change_id)
1914: FROM pn_distributions_history pdh,
1915: pn_distributions_all pd
1916: WHERE pdh.distribution_id = pd.distribution_id
1917: AND pd.payment_term_id = p_term_id;
1918:
1919: CURSOR get_max_term_hist_id_cur(p_term_id IN NUMBER) IS

Line 2669: UPDATE pn_distributions_all

2665: FROM DUAL;
2666:
2667: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_dist_id : '||l_new_dist_id);
2668:
2669: UPDATE pn_distributions_all
2670: SET distribution_id = l_new_dist_id,
2671: payment_term_id = l_new_term_id
2672: WHERE distribution_id = dist_rec.distribution_id;
2673:

Line 3268: INSERT INTO pn_distributions_all

3264: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);
3265: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);
3266: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');
3267:
3268: INSERT INTO pn_distributions_all
3269: (distribution_id
3270: ,account_id
3271: ,payment_term_id
3272: ,term_template_id