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_ELEMENT_TYPE_USAGES_F

Line 53: from pay_element_type_usages_f petu

49:
50:
51:
52: select 1
53: from pay_element_type_usages_f petu
54: where petu.element_type_id = cp_element_type_id
55: and petu.run_type_id = cp_run_type_id
56: and cp_effective_date between petu.effective_start_date
57: and petu.effective_end_date

Line 68: lv_usage_type pay_element_type_usages_f.usage_type%type := NULL;

64: l_object_version_number number;
65: l_effective_start_date date;
66: l_effective_end_date date;
67: ln_exists number;
68: lv_usage_type pay_element_type_usages_f.usage_type%type := NULL;
69:
70:
71:
72: BEGIN

Line 131: delete from PAY_ELEMENT_TYPE_USAGES_F peu1

127: IS
128: BEGIN
129: --{
130: hr_utility.trace('1010 -> Start delete_ele_type_usages ');
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,

Line 134: from PAY_ELEMENT_TYPE_USAGES_F peu2,

130: hr_utility.trace('1010 -> Start delete_ele_type_usages ');
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

Line 251: from pay_element_type_usages_f petu

247: and pet.legislation_code = 'US'
248: and pet.business_group_id IS NULL
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'

Line 329: from pay_element_type_usages_f petu

325: and business_group_id IS NULL
326: and legislation_code = 'US'
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'

Line 428: lv_inclusion_flag pay_element_type_usages_f.inclusion_flag%type;

424: l_field_name PAY_LEGISLATIVE_FIELD_INFO.field_name%type;
425: l_payroll_exist varchar2(10);
426: l_vertex_etu_exist varchar2(10);
427: l_us_tax_vertex_etu_exist varchar2(10);
428: lv_inclusion_flag pay_element_type_usages_f.inclusion_flag%type;
429: l_null_legislation_code pay_element_types_f.legislation_code%type;
430: BEGIN
431: -- hr_utility.trace_on(null, 'PPSELTAX');
432: