APPS.PAY_US_VERTEX_INTERFACE dependencies on PAY_ELEMENT_TYPES_F

Line 136: pay_element_types_F pet

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
140: and peu2.ELEMENT_TYPE_USAGE_ID = peu1.ELEMENT_TYPE_USAGE_ID

Line 244: from pay_element_types_f pet

240: 'US_TAX_VERTEX',decode(l_WAGEACCUM_parm
241: ,'Y','In Use','Not In Use')
242: ,'Not in Use') ,' ')
243: into l_ret_value
244: from pay_element_types_f pet
245: where pet.element_name IN ('VERTEX',
246: 'US_TAX_VERTEX')
247: and pet.legislation_code = 'US'
248: and pet.business_group_id IS NULL

Line 252: ,pay_element_types_f pet1

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'
256: and pet1.business_group_id IS NULL

Line 323: from pay_element_types_f pet

319: --{
320: hr_utility.trace('1300 -> Entering vertex_eletype_usage_exist ');
321: select 'Y'
322: into l_element_type_usage_exist
323: from pay_element_types_f pet
324: where element_name = p_element_name
325: and business_group_id IS NULL
326: and legislation_code = 'US'
327: and exists

Line 330: ,pay_element_types_f pet1

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'
334: and prt.legislation_code = 'US'

Line 412: FROM PAY_ELEMENT_TYPES_F pet

408: pet.element_name,
409: pet.business_group_id,
410: pet.legislation_code,
411: pet.effective_start_date effective_date
412: FROM PAY_ELEMENT_TYPES_F pet
413: WHERE pet.ELEMENT_NAME = c_element_name
414: AND pet.LEGISLATION_CODE = 'US'
415: AND pet.business_group_id IS NULL
416: ORDER by pet.element_name;

Line 429: l_null_legislation_code pay_element_types_f.legislation_code%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:
433: hr_utility.trace('2000 -> Start payustaxinterface.sql ');