APPS.HR_GENERATE_PRETAX dependencies on PAY_USER_TABLES

Line 1374: FROM pay_user_tables

1370: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',53);
1371:
1372: SELECT user_table_id
1373: INTO v_paytab_id
1374: FROM pay_user_tables
1375: WHERE UPPER(user_table_name) = UPPER(p_paytab_name)
1376: AND NVL(business_group_id, p_bg_id) = p_bg_id;
1377:
1378: -- Find row code

Line 1856: -- Else create addl inpval where name = PAY_USER_TABLES.USER_ROW_TITLE

1852: -- 1) If p_paytab_row_type = 'Age Range' or 'Salary Range' then DO NOT create
1853: -- addl inpval;
1854: -- 2) Compare p_paytab_row_type with database item names:
1855: -- If p_paytab_row_type = dbi.name then DO NOT create addl inpval;
1856: -- Else create addl inpval where name = PAY_USER_TABLES.USER_ROW_TITLE
1857: -- (and user_table_name = p_paytab_name)
1858: --
1859:
1860: IF p_paytab_row_type NOT IN ('Salary Range', 'Age Range') THEN