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.PAY_US_VERTEX_INTERFACE dependencies on PAY_RUN_TYPES_F

Line 135: pay_run_types_f prt,

131: delete from PAY_ELEMENT_TYPE_USAGES_F peu1
132: where EXISTS
133: (select 'x'
134: from PAY_ELEMENT_TYPE_USAGES_F peu2,
135: pay_run_types_f prt,
136: pay_element_types_F pet
137: where pet.element_name = p_element_name
138: and peu2.element_type_id = pet.element_type_id
139: and peu2.run_type_id = prt.run_type_id

Line 253: ,pay_run_types_f prt

249: and NOT EXISTS
250: ( select 'x'
251: from pay_element_type_usages_f petu
252: ,pay_element_types_f pet1
253: ,pay_run_types_f prt
254: where petu.element_type_id = pet1.element_type_id
255: and pet1.legislation_code = 'US'
256: and pet1.business_group_id IS NULL
257: and prt.legislation_code = 'US'

Line 268: ( select 'x' from pay_run_types_f prt1

264: and pet1.business_group_id IS NULL
265: and pet1.legislation_code = 'US'
266: and prt.legislation_code = 'US'
267: and exists
268: ( select 'x' from pay_run_types_f prt1
269: where prt1.run_type_name IN ('Regular Standard Run',
270: 'Separate Payment Run',
271: 'Tax Separate Run',
272: 'Supplemental Standard Run',

Line 331: ,pay_run_types_f prt

327: and exists
328: ( select 'x'
329: from pay_element_type_usages_f petu
330: ,pay_element_types_f pet1
331: ,pay_run_types_f prt
332: where petu.element_type_id = pet1.element_type_id
333: and pet1.legislation_code = 'US'
334: and prt.legislation_code = 'US'
335: and petu.run_type_id = prt.run_type_id

Line 340: ( select 'x' from pay_run_types_f prt1

336: and petu.business_group_id = p_business_group_id --IS NULL
337: and petu.legislation_code IS NULL --= 'US'
338: and petu.element_Type_id = pet.element_type_id
339: and exists
340: ( select 'x' from pay_run_types_f prt1
341: where prt1.run_type_name IN ('Regular Standard Run',
342: 'Separate Payment Run',
343: 'Tax Separate Run',
344: 'Supplemental Standard Run',

Line 393: select prt.* from pay_run_types_f prt

389: -- Run Types used for VERTEX or US_TAX_VERTEX Elements
390:
391: --
392: CURSOR c_run_type is
393: select prt.* from pay_run_types_f prt
394: where prt.run_type_name IN ('Regular Standard Run',
395: 'Separate Payment Run',
396: 'Tax Separate Run',
397: 'Supplemental Standard Run',