APPS.PNRX_RENT_INCREASE_DETAIL dependencies on PN_PAYMENT_TERMS

Line 464: pn_payment_terms_all it,

460: ,it.tax_group_id
461: ,it.tax_included
462: ,it.include_in_var_rent -- slk
463: FROM
464: pn_payment_terms_all it,
465: pn_leases_all l,
466: pn_lease_details_all ld,
467: pn_index_leases il ,
468: pn_index_lease_periods_all ilp'

Line 1086: pn_payment_terms pterm

1082: BEGIN
1083: SELECT distinct hzc.location
1084: INTO l_bill_site
1085: FROM hz_cust_site_uses_all hzc,
1086: pn_payment_terms pterm
1087: WHERE hzc.site_use_id (+) = pterm.customer_site_use_id
1088: AND pterm.customer_site_use_id =p_site_use_id;
1089: v_bill_site := SUBSTR(l_bill_site,1,30);
1090:

Line 1114: pn_payment_terms pterm

1110:
1111: SELECT distinct hzc.location
1112: INTO l_ship_site
1113: FROM hz_cust_site_uses_all hzc,
1114: pn_payment_terms pterm
1115: WHERE hzc.site_use_id (+) = pterm.cust_ship_site_id
1116: AND pterm.cust_ship_site_id =p_site_use_id;
1117: v_ship_site := SUBSTR(l_ship_site,1,30);
1118: