APPS.PN_VARIABLE_TERM_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 173: FROM pn_payment_terms_all

169: ORDER BY inv.invoice_date;
170:
171: CURSOR payment_cur(p_invoice_date DATE,p_var_rent_id NUMBER) IS
172: SELECT payment_term_id
173: FROM pn_payment_terms_all
174: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
175: FROM pn_var_rent_inv_all
176: WHERE invoice_date = p_invoice_date
177: AND var_rent_id = p_var_rent_id);

Line 361: FROM pn_payment_terms_all

357:
358: term_count := 0;
359:
360: SELECT count(*) INTO term_count
361: FROM pn_payment_terms_all
362: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id
363: AND var_rent_type = 'FORECASTED';
364:
365: IF term_count > 0 THEN

Line 459: FROM pn_payment_terms_all

455:
456: term_count := 0;
457:
458: SELECT count(*) INTO term_count
459: FROM pn_payment_terms_all
460: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id
461: AND var_rent_type = 'VARIANCE';
462:
463: IF term_count > 0 THEN

Line 568: FROM pn_payment_terms_all

564:
565: term_count := 0;
566:
567: SELECT count(*) INTO term_count
568: FROM pn_payment_terms_all
569: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
570: AND var_rent_type = 'ACTUAL';
571:
572: IF term_count > 0 THEN

Line 1040: FROM pn_payment_terms_all

1036:
1037: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1038: SELECT count(*)
1039: INTO term_count
1040: FROM pn_payment_terms_all
1041: WHERE var_rent_inv_id = p_var_rent_inv_id
1042: AND var_rent_type = 'ACTUAL';
1043:
1044: IF term_count > 0 THEN

Line 1082: FROM pn_payment_terms_all

1078:
1079: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1080: SELECT count(*)
1081: INTO term_count
1082: FROM pn_payment_terms_all
1083: WHERE var_rent_inv_id = p_var_rent_inv_id
1084: AND var_rent_type = 'ACTUAL';
1085:
1086: IF term_count > 0 THEN

Line 1827: FROM pn_payment_terms_all

1823:
1824: CURSOR payment_term_cur
1825: IS
1826: SELECT *
1827: FROM pn_payment_terms_all
1828: WHERE payment_term_id = p_payment_term_id;
1829:
1830: term_count NUMBER := 0;
1831:

Line 1991: FROM pn_payment_terms_all

1987:
1988: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1989: SELECT count(*)
1990: INTO term_count
1991: FROM pn_payment_terms_all
1992: WHERE var_rent_inv_id = p_var_rent_inv_id
1993: AND var_rent_type = 'ACTUAL';
1994:
1995: IF term_count > 0 THEN

Line 2034: FROM pn_payment_terms_all

2030:
2031: IF p_var_rent_type <> 'ADJUSTMENT' THEN
2032: SELECT count(*)
2033: INTO term_count
2034: FROM pn_payment_terms_all
2035: WHERE var_rent_inv_id = p_var_rent_inv_id
2036: AND var_rent_type = 'ACTUAL';
2037:
2038: IF term_count > 0 THEN