[Home] [Help]
1237: pop.ORGANIZATION_ID,
1238: pop.BUSINESS_GROUP_ID,
1239: punits.name ORGANIZATION_NAME,
1240: pop.availability_status_id
1241: from hr_positions_f pop,
1242: per_organization_units punits
1243: WHERE trunc(effective_DATE) between pop.effective_start_DATE and pop.effective_END_DATE
1244: and pop.organization_id = punits.organization_id
1245: and pop.organization_id = nvl(p_org_pos_id,pop.organization_id)
1259:
1260: ----Bug 4699955
1261: cursor c_pos_name (p_position_id NUMBER)
1262: is
1263: select name from hr_positions_f
1264: where position_id = p_position_id;
1265:
1266: l_pos_name hr_positions_f.name%type;
1267: ----Bug 4699955
1262: is
1263: select name from hr_positions_f
1264: where position_id = p_position_id;
1265:
1266: l_pos_name hr_positions_f.name%type;
1267: ----Bug 4699955
1268:
1269: l_assignment_id per_assignments_f.assignment_id%type;
1270: l_position_id per_assignments_f.position_id%type;
5374: raise mtc_error;
5375: END check_select_flg_pos;
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
5396: AND pah.effective_date >= to_date('2005/05/01','YYYY/MM/DD')
5397: AND pah.effective_date > l_eff_date
5398: AND to_number(pah.information4) in
5399: (SELECT position_id
5400: from hr_positions_f pos
5401: WHERE pos.position_id = to_number(pah.information4)
5402: AND pah.effective_date
5403: between pos.effective_start_date and pos.effective_end_date
5404: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id) = 'Active');