APPS.PNRX_RENT_INCREASE_DETAIL dependencies on HZ_CUST_SITE_USES_ALL

Line 1085: FROM hz_cust_site_uses_all hzc,

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

Line 1113: FROM hz_cust_site_uses_all hzc,

1109: BEGIN
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);