[Home] [Help]
1263: pop.ORGANIZATION_ID,
1264: pop.BUSINESS_GROUP_ID,
1265: punits.name ORGANIZATION_NAME,
1266: pop.availability_status_id
1267: from hr_positions_f pop,
1268: per_organization_units punits
1269: WHERE trunc(effective_DATE) between pop.effective_start_DATE and pop.effective_END_DATE
1270: and pop.organization_id = punits.organization_id
1271: and pop.organization_id = nvl(p_org_pos_id,pop.organization_id)
1285:
1286: ----Bug 4699955
1287: cursor c_pos_name (p_position_id NUMBER)
1288: is
1289: select name from hr_positions_f
1290: where position_id = p_position_id;
1291:
1292: l_pos_name hr_positions_f.name%type;
1293: ----Bug 4699955
1288: is
1289: select name from hr_positions_f
1290: where position_id = p_position_id;
1291:
1292: l_pos_name hr_positions_f.name%type;
1293: ----Bug 4699955
1294:
1295: l_assignment_id per_assignments_f.assignment_id%type;
1296: l_position_id per_assignments_f.position_id%type;
5432: raise mtc_error;
5433: END check_select_flg_pos;
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
5454: AND pah.effective_date >= to_date('2005/05/01','YYYY/MM/DD')
5455: AND pah.effective_date > l_eff_date
5456: AND to_number(pah.information4) in
5457: (SELECT position_id
5458: from hr_positions_f pos
5459: WHERE pos.position_id = to_number(pah.information4)
5460: AND pah.effective_date
5461: between pos.effective_start_date and pos.effective_end_date
5462: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id) = 'Active');