eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PN_VAREN_UTIL dependencies on PN_VAR_RENTS_ALL

Line 253: FROM pn_var_rents_all

249:
250: CURSOR c_rent_num
251: IS
252: SELECT var_rent_id
253: FROM pn_var_rents_all
254: WHERE UPPER (rent_num) = UPPER (x_rent_num)
255: AND lease_id = p_lease_id
256: AND org_id = p_org_id;
257: BEGIN

Line 1293: FROM pn_var_rents_all

1289: SELECT commencement_date
1290: , termination_date
1291: INTO x_commencement_date
1292: , x_termination_date
1293: FROM pn_var_rents_all
1294: WHERE var_rent_id = p_var_rent_id
1295: AND org_id = p_org_id;
1296:
1297: x_return_status := fnd_api.g_ret_sts_success;

Line 1442: FROM pn_var_rents_all

1438: IS
1439: SELECT var_rent_id
1440: , lease_id
1441: , location_id
1442: FROM pn_var_rents_all
1443: WHERE UPPER (rent_num) = UPPER (p_rent_num);
1444: BEGIN
1445: x_return_status := fnd_api.g_ret_sts_success;
1446:

Line 1491: FROM pn_var_rents_all

1487: SELECT p_rent_num
1488: , var_rent_id
1489: -- , lease_id
1490: -- , location_id
1491: FROM pn_var_rents_all
1492: WHERE UPPER (rent_num) = UPPER (NVL(p_rent_num,rent_num))
1493: AND var_rent_id= NVL(x_var_rent_id,var_rent_id);
1494: BEGIN
1495: