APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_DISTRIBUTIONS_HISTORY_S1

Line 1991: SELECT pn_distributions_history_s1.NEXTVAL

1987:
1988: IF NVL(p_hist_dist_tab.count,0) <> 0 AND
1989: NVL(tlinfo.term_altered_flag, 'N') = 'N' THEN
1990:
1991: SELECT pn_distributions_history_s1.NEXTVAL
1992: INTO l_dist_change_id
1993: FROM DUAL;
1994:
1995: pnp_debug_pkg.debug('create_hist_corr_upd : l_dist_change_id :'||l_dist_change_id);

Line 2286: SELECT pn_distributions_history_s1.NEXTVAL

2282:
2283: IF NVL(p_dist_changed, 0) > 0 AND
2284: p_change_mode = 'CORRECT' THEN
2285:
2286: SELECT pn_distributions_history_s1.NEXTVAL
2287: INTO l_dist_change_id
2288: FROM DUAL;
2289:
2290: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id : '||l_dist_change_id);

Line 2650: SELECT pn_distributions_history_s1.NEXTVAL

2646: changed_flag = 'N',
2647: payment_term_id = l_new_term_id
2648: WHERE payment_term_id = p_term_id;
2649:
2650: SELECT pn_distributions_history_s1.NEXTVAL
2651: INTO l_dist_change_id
2652: FROM DUAL;
2653:
2654: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);

Line 3231: SELECT pn_distributions_history_s1.NEXTVAL

3227: ,tlinfo.term_comments);
3228:
3229: IF NVL(p_hist_dist_tab.count,0) <> 0 THEN
3230:
3231: SELECT pn_distributions_history_s1.NEXTVAL
3232: INTO l_dist_change_id
3233: FROM DUAL;
3234:
3235: l_insert_dist_hist := 'N';