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.

APPS.PN_LEASE_PVT dependencies on DUAL

Line 15627: FROM dual;

15623: END;
15624: BEGIN
15625: SELECT p_payment_terms_tbl(i).expenditure_item_date
15626: INTO l_check_date
15627: FROM dual;
15628: EXCEPTION
15629: WHEN OTHERS THEN
15630: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
15631: fnd_message.set_token('ERR_MSG', 'Invalid Expenditure Date for the Payment ID:'||p_payment_terms_tbl(i).payment_term_id);

Line 18496: FROM dual;

18492: l_char VARCHAR2(4000);
18493: BEGIN
18494: SELECT decode (p_parameter,pn_lease_utils.g_pn_miss_char,'',p_parameter)
18495: INTO l_char
18496: FROM dual;
18497: RETURN l_char;
18498: EXCEPTION
18499: WHEN OTHERS THEN
18500: pvt_debug(g_pkg_name||'-get_miss_char_decode:Exception'||SQLERRM,3);

Line 18512: FROM dual;

18508: l_num NUMBER;
18509: BEGIN
18510: SELECT decode (p_parameter,pn_lease_utils.g_pn_miss_num,'',p_parameter)
18511: INTO l_num
18512: FROM dual;
18513: RETURN l_num;
18514: EXCEPTION
18515: WHEN OTHERS THEN
18516: pvt_debug(g_pkg_name||'-get_miss_num_decode:Exception'||SQLERRM,3);

Line 18528: FROM dual;

18524: l_date DATE;
18525: BEGIN
18526: SELECT decode (p_parameter,pn_lease_utils.g_pn_miss_date,'',p_parameter)
18527: INTO l_date
18528: FROM dual;
18529: RETURN l_date;
18530: EXCEPTION
18531: WHEN OTHERS THEN
18532: pvt_debug(g_pkg_name||'-get_miss_date_decode:Exception'||SQLERRM,3);

Line 18660: FROM dual

18656: CURSOR c_location_exists( p_lease_id IN NUMBER
18657: , p_org_id IN NUMBER
18658: )
18659: IS SELECT 'Y'
18660: FROM dual
18661: WHERE EXISTS (SELECT 1
18662: FROM pn_tenancies_ALL
18663: WHERE lease_id= p_lease_id
18664: AND org_id = g_org_id