APPS.GHR_MLC_PKG dependencies on PAY_USER_TABLES

Line 220: CURSOR c_pay_tab_type(p_user_table_id pay_user_tables.user_table_id%type)

216: l_essl_table BOOLEAN := FALSE;
217: l_org_name hr_organization_units.name%type;
218: l_table_type VARCHAR2(2);
219:
220: CURSOR c_pay_tab_type(p_user_table_id pay_user_tables.user_table_id%type)
221: is
222: SELECT range_or_match
223: FROM pay_user_tables
224: WHERE user_table_id = p_user_table_id;

Line 223: FROM pay_user_tables

219:
220: CURSOR c_pay_tab_type(p_user_table_id pay_user_tables.user_table_id%type)
221: is
222: SELECT range_or_match
223: FROM pay_user_tables
224: WHERE user_table_id = p_user_table_id;
225:
226: BEGIN
227: g_proc := 'execute_mlc';

Line 1465: select user_table_id from pay_user_tables

1461: WHERE grd.grade_id = grd_id
1462: and grd.grade_definition_id = gdf.grade_definition_id;
1463:
1464: cursor c_pay_table_id (pay_table varchar2) is
1465: select user_table_id from pay_user_tables
1466: where substr(user_table_name,1,4) = pay_table;
1467:
1468:
1469:

Line 3196: from pay_user_tables

3192:
3193: FUNCTION GET_USER_TABLE_name (P_USER_TABLE_id IN NUMBER) RETURN VARCHAR2 IS
3194: CURSOR MSL_CUR IS
3195: select user_table_id,substr(user_table_name,0,4) user_table_name
3196: from pay_user_tables
3197: where substr(user_table_name,6,14) in
3198: ('Oracle Federal','Federal Agency')
3199: and user_table_id = p_user_table_id;
3200: l_user_table_name varchar2(80);

Line 5380: p_table_id IN pay_user_tables.user_table_id%type,

5376:
5377:
5378: procedure position_history_update (p_position_id IN hr_positions_f.position_id%type,
5379: p_effective_date IN date,
5380: p_table_id IN pay_user_tables.user_table_id%type,
5381: p_upd_tableid IN pay_user_tables.user_table_id%type)
5382: is
5383:
5384: CURSOR cur_hist_rows(l_tab_id NUMBER,l_eff_date date, l_pos_id NUMBER)

Line 5381: p_upd_tableid IN pay_user_tables.user_table_id%type)

5377:
5378: procedure position_history_update (p_position_id IN hr_positions_f.position_id%type,
5379: p_effective_date IN date,
5380: p_table_id IN pay_user_tables.user_table_id%type,
5381: p_upd_tableid IN pay_user_tables.user_table_id%type)
5382: is
5383:
5384: CURSOR cur_hist_rows(l_tab_id NUMBER,l_eff_date date, l_pos_id NUMBER)
5385: IS

Line 5409: l_user_tab_id pay_user_tables.user_table_id%type;

5405:
5406: l_hist_id ghr_pa_history.pa_history_id%type;
5407: l_position_id per_assignments_f.position_id%type;
5408: l_his_eff_date ghr_pa_requests.effective_date%type;
5409: l_user_tab_id pay_user_tables.user_table_id%type;
5410:
5411:
5412: begin
5413: FOR hist_rec IN cur_hist_rows(p_table_id,p_effective_date,p_position_id)