DBA Data[Home] [Help]

APPS.PAY_US_VERTEX_INTERFACE dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 424: l_field_name PAY_LEGISLATIVE_FIELD_INFO.field_name%type;

420: ln_commit_counter number;
421: l_wage_exists number;
422: lv_exists varchar2(1);
423: lv_interoperable_flag varchar2(10);
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;

Line 447: FROM PAY_LEGISLATIVE_FIELD_INFO

443: hr_startup_data_api_support.create_owner_definition('PAY');
444: BEGIN
445: SELECT field_name
446: INTO l_field_name
447: FROM PAY_LEGISLATIVE_FIELD_INFO
448: WHERE FIELD_NAME = 'ET_USAGE'
449: AND LEGISLATION_CODE = 'US';
450: EXCEPTION
451: WHEN NO_DATA_FOUND THEN

Line 452: INSERT INTO PAY_LEGISLATIVE_FIELD_INFO

448: WHERE FIELD_NAME = 'ET_USAGE'
449: AND LEGISLATION_CODE = 'US';
450: EXCEPTION
451: WHEN NO_DATA_FOUND THEN
452: INSERT INTO PAY_LEGISLATIVE_FIELD_INFO
453: (FIELD_NAME,
454: LEGISLATION_CODE,
455: RULE_TYPE,
456: RULE_MODE)