APPS.GHR_MLC_PKG dependencies on PAY_USER_TABLES

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

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

Line 225: FROM pay_user_tables

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

Line 1491: select user_table_id from pay_user_tables

1487: WHERE grd.grade_id = grd_id
1488: and grd.grade_definition_id = gdf.grade_definition_id;
1489:
1490: cursor c_pay_table_id (pay_table varchar2) is
1491: select user_table_id from pay_user_tables
1492: where substr(user_table_name,1,4) = pay_table;
1493:
1494:
1495:

Line 3242: from pay_user_tables

3238:
3239: FUNCTION GET_USER_TABLE_name (P_USER_TABLE_id IN NUMBER) RETURN VARCHAR2 IS
3240: CURSOR MSL_CUR IS
3241: select user_table_id,substr(user_table_name,0,4) user_table_name
3242: from pay_user_tables
3243: where substr(user_table_name,6,14) in
3244: ('Oracle Federal','Federal Agency')
3245: and user_table_id = p_user_table_id;
3246: l_user_table_name varchar2(80);

Line 5438: p_table_id IN pay_user_tables.user_table_id%type,

5434:
5435:
5436: procedure position_history_update (p_position_id IN hr_positions_f.position_id%type,
5437: p_effective_date IN date,
5438: p_table_id IN pay_user_tables.user_table_id%type,
5439: p_upd_tableid IN pay_user_tables.user_table_id%type)
5440: is
5441:
5442: CURSOR cur_hist_rows(l_tab_id NUMBER,l_eff_date date, l_pos_id NUMBER)

Line 5439: p_upd_tableid IN pay_user_tables.user_table_id%type)

5435:
5436: procedure position_history_update (p_position_id IN hr_positions_f.position_id%type,
5437: p_effective_date IN date,
5438: p_table_id IN pay_user_tables.user_table_id%type,
5439: p_upd_tableid IN pay_user_tables.user_table_id%type)
5440: is
5441:
5442: CURSOR cur_hist_rows(l_tab_id NUMBER,l_eff_date date, l_pos_id NUMBER)
5443: IS

Line 5467: l_user_tab_id pay_user_tables.user_table_id%type;

5463:
5464: l_hist_id ghr_pa_history.pa_history_id%type;
5465: l_position_id per_assignments_f.position_id%type;
5466: l_his_eff_date ghr_pa_requests.effective_date%type;
5467: l_user_tab_id pay_user_tables.user_table_id%type;
5468:
5469:
5470: begin
5471: FOR hist_rec IN cur_hist_rows(p_table_id,p_effective_date,p_position_id)