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_CMN_RG_OPM_PKG dependencies on JAI_CMN_FIN_YEARS

Line 69: CURSOR fin_year_cur (cpn_organization_id jai_cmn_fin_years.organization_id%type)

65: Select transaction_date
66: From JAI_OPM_OSP_HDRS
67: Where osp_header_id = p_ospheader;
68:
69: CURSOR fin_year_cur (cpn_organization_id jai_cmn_fin_years.organization_id%type)
70: IS
71: select
72: max(a.fin_year)
73: from

Line 74: JAI_CMN_FIN_YEARS a

70: IS
71: select
72: max(a.fin_year)
73: from
74: JAI_CMN_FIN_YEARS a
75: where a.organization_id = cpn_organization_id
76: and a.fin_active_flag = 'Y';
77:
78: srno NUMBER;

Line 624: from JAI_CMN_FIN_YEARS a

620: where osp_header_id = p_ospheader ;
621:
622: cursor fin_year_cur IS
623: select max(a.fin_year)
624: from JAI_CMN_FIN_YEARS a
625: where a.organization_id = p_organization_id
626: and a.fin_active_flag = 'Y';
627:
628: