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

Line 173: from dual;

169: ,v_user_id
170: ,sysdate
171: ,null
172: ,1
173: from dual;
174:
175: EXCEPTION
176: when dup_val_on_index then null;
177: END;

Line 187: from dual;

183: where calendar_display_code='Default';
184:
185: select trunc(sysdate,'YYYY')
186: into v_start_date
187: from dual;
188:
189: v_end_date := LAST_DAY(ADD_MONTHS(v_start_date,11));
190:
191:

Line 197: from dual;

193: LPAD(TO_CHAR(c_cal_period_number),15,'0')||
194: LPAD(to_char(v_calendar_id),5,'0')||
195: LPAD(to_char(c_time_dim_group_key),5,'0')
196: into v_cal_period_id
197: from dual;
198:
199:
200: select dimension_group_id
201: into v_dimension_group_id

Line 220: from dual;

216: and dimension_id=1;
217:
218: select to_number(to_char(sysdate,'YYYY'))
219: into v_accounting_year
220: from dual;
221:
222: select source_system_code, source_system_display_code
223: into v_source_system_code, v_source_system_dc
224: from fem_source_systems_b

Line 1148: WHERE bus_rel_display_code = 'INDIVIDUAL_CUSTOMER';

1144:
1145: SELECT bus_rel_id
1146: INTO v_bus_rel_mbr_id
1147: FROM fem_bus_rel_b
1148: WHERE bus_rel_display_code = 'INDIVIDUAL_CUSTOMER';
1149:
1150: SELECT dimension_id
1151: INTO v_customer_dim_id
1152: FROM fem_dimensions_b