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.JAI_AR_EER1_PKG dependencies on DUAL

Line 3653: select to_char(p_start_date, 'YYYYMM') from dual ;

3649: lv_notf_sno varchar2(10);
3650:
3651: Cursor c_year_month
3652: is
3653: select to_char(p_start_date, 'YYYYMM') from dual ;
3654:
3655: Cursor c_cur_dtls
3656: is
3657: select

Line 3775: select to_char(p_start_date, 'YYYYMM') from dual ;

3771: ld_misc_source_date date;
3772:
3773: Cursor c_year_month
3774: is
3775: select to_char(p_start_date, 'YYYYMM') from dual ;
3776:
3777: BEGIN
3778:
3779: lv_record_header := 'PAYMENT_DETAIL' ;

Line 3873: select to_char(p_start_date, 'YYYYMM') from dual ;

3869: lv_name_auth_sign varchar2(40);
3870:
3871: Cursor c_year_month
3872: is
3873: select to_char(p_start_date, 'YYYYMM') from dual ;
3874:
3875: Cursor c_tr6_challan_amt
3876: is
3877: select NVL(SUM(pla_amount),0)