APPS.PNT_PAYMENT_TERMS_PKG dependencies on DUAL

Line 1194: FROM dual

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

Line 1587: FROM DUAL;

1583: SELECT TRUNC(x_start_date, 'MM')
1584: ,LAST_DAY(x_end_date)
1585: INTO l_startDate
1586: ,l_endDate
1587: FROM DUAL;
1588:
1589: OPEN c_chk_app_sch;
1590: FETCH c_chk_app_sch INTO l_leaseNumber;
1591: IF (c_chk_app_sch%NOTFOUND) THEN

Line 1993: FROM DUAL;

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);
1996:
1997: FOR i in 1..p_hist_dist_tab.count LOOP

Line 2288: FROM DUAL;

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);
2291:
2292: FOR dist_rec IN get_dist_cur(p_term_id) LOOP

Line 2634: FROM DUAL;

2630: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2631:
2632: SELECT pn_payment_terms_s.nextval
2633: INTO l_new_term_id
2634: FROM DUAL;
2635:
2636: l_adj_type_code := NULL;
2637: l_term_comments := NULL;
2638:

Line 2652: FROM DUAL;

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);
2655:
2656: FOR dist_rec IN get_dist_cur(p_term_id) LOOP

Line 2661: FROM DUAL;

2657:
2658: l_new_dist_id := NULL;
2659: SELECT pn_distributions_s.nextval
2660: INTO l_new_dist_id
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

Line 3010: FROM DUAL;

3006: i = 1) THEN
3007:
3008: SELECT pn_payment_terms_s.nextval
3009: INTO l_term_id
3010: FROM DUAL;
3011:
3012: l_str_dt := NVL(p_eff_end_dt, term_rec.end_date) + 1;
3013: l_end_dt := term_rec.end_date;
3014: l_adj_type_code := NULL;

Line 3233: FROM DUAL;

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';
3236:
3237: FOR j in 1..p_hist_dist_tab.count LOOP

Line 3254: FROM DUAL;

3250: i = 1) THEN
3251:
3252: SELECT pn_distributions_s.NEXTVAL
3253: INTO l_dist_id
3254: FROM DUAL;
3255:
3256: l_insert_dist_hist := 'Y';
3257:
3258: END IF;

Line 3676: FROM DUAL;

3672: ELSE
3673:
3674: SELECT NULL
3675: INTO l_agreement_number
3676: FROM DUAL;
3677:
3678: END IF;
3679: END LOOP;
3680: