DBA Data[Home] [Help]

APPS.HR_USER_INIT_DEDN dependencies on PAY_USER_TABLES

Line 1098: FROM pay_user_tables

1094: -- Find table id
1095: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',53);
1096: SELECT user_table_id
1097: INTO v_paytab_id
1098: FROM pay_user_tables
1099: WHERE UPPER(user_table_name) = UPPER(p_paytab_name)
1100: AND NVL(business_group_id, p_bg_id) = p_bg_id;
1101: -- Find row code
1102: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',55);

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

1262: -- 1) If p_paytab_row_type = 'Age Range' or 'Salary Range' then DO NOT create
1263: -- addl inpval;
1264: -- 2) Compare p_paytab_row_type with database item names:
1265: -- If p_paytab_row_type = dbi.name then DO NOT create addl inpval;
1266: -- Else create addl inpval where name = PAY_USER_TABLES.USER_ROW_TITLE
1267: -- (and user_table_name = p_paytab_name)
1268: --
1269:
1270: IF p_paytab_row_type NOT IN ('Salary Range', 'Age Range') THEN