APPS.PNT_PAYMENT_TERMS_PKG dependencies on DUAL

Line 1196: FROM dual

1192: )
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;

Line 1591: FROM DUAL;

1587: SELECT TRUNC(x_start_date, 'MM')
1588: ,LAST_DAY(x_end_date)
1589: INTO l_startDate
1590: ,l_endDate
1591: FROM DUAL;
1592:
1593: OPEN c_chk_app_sch;
1594: FETCH c_chk_app_sch INTO l_leaseNumber;
1595: IF (c_chk_app_sch%NOTFOUND) THEN

Line 1997: FROM DUAL;

1993: NVL(tlinfo.term_altered_flag, 'N') = 'N' THEN
1994:
1995: SELECT pn_distributions_history_s1.NEXTVAL
1996: INTO l_dist_change_id
1997: FROM DUAL;
1998:
1999: pnp_debug_pkg.debug('create_hist_corr_upd : l_dist_change_id :'||l_dist_change_id);
2000:
2001: FOR i in 1..p_hist_dist_tab.count LOOP

Line 2292: FROM DUAL;

2288: p_change_mode = 'CORRECT' THEN
2289:
2290: SELECT pn_distributions_history_s1.NEXTVAL
2291: INTO l_dist_change_id
2292: FROM DUAL;
2293:
2294: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id : '||l_dist_change_id);
2295:
2296: FOR dist_rec IN get_dist_cur(p_term_id) LOOP

Line 2638: FROM DUAL;

2634: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2635:
2636: SELECT pn_payment_terms_s.nextval
2637: INTO l_new_term_id
2638: FROM DUAL;
2639:
2640: l_adj_type_code := NULL;
2641: l_term_comments := NULL;
2642:

Line 2656: FROM DUAL;

2652: WHERE payment_term_id = p_term_id;
2653:
2654: SELECT pn_distributions_history_s1.NEXTVAL
2655: INTO l_dist_change_id
2656: FROM DUAL;
2657:
2658: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);
2659:
2660: FOR dist_rec IN get_dist_cur(p_term_id) LOOP

Line 2665: FROM DUAL;

2661:
2662: l_new_dist_id := NULL;
2663: SELECT pn_distributions_s.nextval
2664: INTO l_new_dist_id
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

Line 3014: FROM DUAL;

3010: i = 1) THEN
3011:
3012: SELECT pn_payment_terms_s.nextval
3013: INTO l_term_id
3014: FROM DUAL;
3015:
3016: l_str_dt := NVL(p_eff_end_dt, term_rec.end_date) + 1;
3017: l_end_dt := term_rec.end_date;
3018: l_adj_type_code := NULL;

Line 3237: FROM DUAL;

3233: IF NVL(p_hist_dist_tab.count,0) <> 0 THEN
3234:
3235: SELECT pn_distributions_history_s1.NEXTVAL
3236: INTO l_dist_change_id
3237: FROM DUAL;
3238:
3239: l_insert_dist_hist := 'N';
3240:
3241: FOR j in 1..p_hist_dist_tab.count LOOP

Line 3258: FROM DUAL;

3254: i = 1) THEN
3255:
3256: SELECT pn_distributions_s.NEXTVAL
3257: INTO l_dist_id
3258: FROM DUAL;
3259:
3260: l_insert_dist_hist := 'Y';
3261:
3262: END IF;

Line 3680: FROM DUAL;

3676: ELSE
3677:
3678: SELECT NULL
3679: INTO l_agreement_number
3680: FROM DUAL;
3681:
3682: END IF;
3683: END LOOP;
3684: