APPS.PN_VARIABLE_TERM_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 176: FROM pn_payment_terms_all

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

Line 365: FROM pn_payment_terms_all

361:
362: term_count := 0;
363:
364: SELECT count(*) INTO term_count
365: FROM pn_payment_terms_all
366: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id
367: AND var_rent_type = 'FORECASTED';
368:
369: IF term_count > 0 THEN

Line 463: FROM pn_payment_terms_all

459:
460: term_count := 0;
461:
462: SELECT count(*) INTO term_count
463: FROM pn_payment_terms_all
464: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id
465: AND var_rent_type = 'VARIANCE';
466:
467: IF term_count > 0 THEN

Line 572: FROM pn_payment_terms_all

568:
569: term_count := 0;
570:
571: SELECT count(*) INTO term_count
572: FROM pn_payment_terms_all
573: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
574: AND var_rent_type = 'ACTUAL';
575:
576: IF term_count > 0 THEN

Line 1044: FROM pn_payment_terms_all

1040:
1041: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1042: SELECT count(*)
1043: INTO term_count
1044: FROM pn_payment_terms_all
1045: WHERE var_rent_inv_id = p_var_rent_inv_id
1046: AND var_rent_type = 'ACTUAL';
1047:
1048: IF term_count > 0 THEN

Line 1086: FROM pn_payment_terms_all

1082:
1083: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1084: SELECT count(*)
1085: INTO term_count
1086: FROM pn_payment_terms_all
1087: WHERE var_rent_inv_id = p_var_rent_inv_id
1088: AND var_rent_type = 'ACTUAL';
1089:
1090: IF term_count > 0 THEN

Line 1831: FROM pn_payment_terms_all

1827:
1828: CURSOR payment_term_cur
1829: IS
1830: SELECT *
1831: FROM pn_payment_terms_all
1832: WHERE payment_term_id = p_payment_term_id;
1833:
1834: term_count NUMBER := 0;
1835:

Line 1995: FROM pn_payment_terms_all

1991:
1992: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1993: SELECT count(*)
1994: INTO term_count
1995: FROM pn_payment_terms_all
1996: WHERE var_rent_inv_id = p_var_rent_inv_id
1997: AND var_rent_type = 'ACTUAL';
1998:
1999: IF term_count > 0 THEN

Line 2038: FROM pn_payment_terms_all

2034:
2035: IF p_var_rent_type <> 'ADJUSTMENT' THEN
2036: SELECT count(*)
2037: INTO term_count
2038: FROM pn_payment_terms_all
2039: WHERE var_rent_inv_id = p_var_rent_inv_id
2040: AND var_rent_type = 'ACTUAL';
2041:
2042: IF term_count > 0 THEN