DBA Data[Home] [Help]

APPS.HR_USER_INIT_DEDN dependencies on PAY_USER_TABLES

Line 1110: FROM pay_user_tables

1106: -- Find table id
1107: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',53);
1108: SELECT user_table_id
1109: INTO v_paytab_id
1110: FROM pay_user_tables
1111: WHERE UPPER(user_table_name) = UPPER(p_paytab_name)
1112: AND NVL(business_group_id, p_bg_id) = p_bg_id;
1113: -- Find row code
1114: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',55);

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

1274: -- 1) If p_paytab_row_type = 'Age Range' or 'Salary Range' then DO NOT create
1275: -- addl inpval;
1276: -- 2) Compare p_paytab_row_type with database item names:
1277: -- If p_paytab_row_type = dbi.name then DO NOT create addl inpval;
1278: -- Else create addl inpval where name = PAY_USER_TABLES.USER_ROW_TITLE
1279: -- (and user_table_name = p_paytab_name)
1280: --
1281:
1282: IF p_paytab_row_type NOT IN ('Salary Range', 'Age Range') THEN