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.IMC_CSV_LOAD dependencies on AR_LOOKUPS

Line 192: select count(*) from ar_lookups where lookup_type='LEGAL_STATUS' and lookup_code=legal_status_cd

188: -- Bug 4310048/4315682 : do not show invalid lookups
189: -- Add check for ENABLED_FLAG and END_DATE_ACTIVE
190:
191: cursor legal_status_code(legal_status_cd VARCHAR2) is
192: select count(*) from ar_lookups where lookup_type='LEGAL_STATUS' and lookup_code=legal_status_cd
193: AND ENABLED_FLAG = 'Y'
194: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
195:
196: cursor hq_branch(hq_branch_ind_cd VARCHAR2) is

Line 197: select count(*) from ar_lookups where lookup_type='HQ_BRANCH_IND' and lookup_code=hq_branch_ind_cd

193: AND ENABLED_FLAG = 'Y'
194: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
195:
196: cursor hq_branch(hq_branch_ind_cd VARCHAR2) is
197: select count(*) from ar_lookups where lookup_type='HQ_BRANCH_IND' and lookup_code=hq_branch_ind_cd
198: AND ENABLED_FLAG = 'Y'
199: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
200:
201: cursor FISCAL_YREND_MONTH(fiscal_yearend_month_cd VARCHAR2) is

Line 202: select count(*) from ar_lookups where lookup_type='MONTH' and lookup_code = fiscal_yearend_month_cd

198: AND ENABLED_FLAG = 'Y'
199: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
200:
201: cursor FISCAL_YREND_MONTH(fiscal_yearend_month_cd VARCHAR2) is
202: select count(*) from ar_lookups where lookup_type='MONTH' and lookup_code = fiscal_yearend_month_cd
203: AND ENABLED_FLAG = 'Y'
204: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
205:
206: cursor REGISTRY_TYPE(registration_type_cd VARCHAR2) is

Line 207: select count(*) from ar_lookups where lookup_type='REGISTRATION_TYPE' and lookup_code=registration_type_cd

203: AND ENABLED_FLAG = 'Y'
204: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
205:
206: cursor REGISTRY_TYPE(registration_type_cd VARCHAR2) is
207: select count(*) from ar_lookups where lookup_type='REGISTRATION_TYPE' and lookup_code=registration_type_cd
208: AND ENABLED_FLAG = 'Y'
209: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
210:
211: cursor contact_title(pre_name_adjunct VARCHAR2) is

Line 212: select count(*) from ar_lookups where lookup_type='CONTACT_TITLE' and lookup_code=pre_name_adjunct

208: AND ENABLED_FLAG = 'Y'
209: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
210:
211: cursor contact_title(pre_name_adjunct VARCHAR2) is
212: select count(*) from ar_lookups where lookup_type='CONTACT_TITLE' and lookup_code=pre_name_adjunct
213: AND ENABLED_FLAG = 'Y'
214: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
215:
216: cursor marry_status(marital_status_cd VARCHAR2) is

Line 217: select count(*) from ar_lookups where lookup_type='MARITAL_STATUS' and lookup_code=marital_status_cd

213: AND ENABLED_FLAG = 'Y'
214: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
215:
216: cursor marry_status(marital_status_cd VARCHAR2) is
217: select count(*) from ar_lookups where lookup_type='MARITAL_STATUS' and lookup_code=marital_status_cd
218: AND ENABLED_FLAG = 'Y'
219: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
220:
221: cursor own_rent(own_rent_cd VARCHAR2) is

Line 222: select count(*) from ar_lookups where lookup_type='OWN_RENT_IND' and lookup_code=own_rent_cd

218: AND ENABLED_FLAG = 'Y'
219: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
220:
221: cursor own_rent(own_rent_cd VARCHAR2) is
222: select count(*) from ar_lookups where lookup_type='OWN_RENT_IND' and lookup_code=own_rent_cd
223: AND ENABLED_FLAG = 'Y'
224: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
225:
226: cursor contact_pnt_type(contact_pnt_type_cd VARCHAR2) is

Line 227: select count(*) from ar_lookups where lookup_type='COMMUNICATION_TYPE' and lookup_code=contact_pnt_type_cd

223: AND ENABLED_FLAG = 'Y'
224: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
225:
226: cursor contact_pnt_type(contact_pnt_type_cd VARCHAR2) is
227: select count(*) from ar_lookups where lookup_type='COMMUNICATION_TYPE' and lookup_code=contact_pnt_type_cd
228: AND ENABLED_FLAG = 'Y'
229: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
230:
231: -- Bug 4310158: Should only allow valid country code

Line 242: select count(*) from ar_lookups where lookup_type = class_category and lookup_code = class_code

238: cursor clss_category(p_class_category VARCHAR2) is
239: select count(*) from hz_class_categories where class_category = p_class_category;
240:
241: cursor clss_code(class_category VARCHAR2,class_code VARCHAR2) is
242: select count(*) from ar_lookups where lookup_type = class_category and lookup_code = class_code
243: AND ENABLED_FLAG = 'Y'
244: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
245:
246: cursor ph_line_type(ph_line_type_value VARCHAR2) is

Line 247: select count(*) from ar_lookups where lookup_type='PHONE_LINE_TYPE' and lookup_code=ph_line_type_value

243: AND ENABLED_FLAG = 'Y'
244: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
245:
246: cursor ph_line_type(ph_line_type_value VARCHAR2) is
247: select count(*) from ar_lookups where lookup_type='PHONE_LINE_TYPE' and lookup_code=ph_line_type_value
248: AND ENABLED_FLAG = 'Y'
249: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
250:
251: BEGIN