APPS.PSB_BUDGET_POSITION_PVT dependencies on PSB_POSITIONS

Line 260: p_position_id IN psb_positions.position_id%TYPE,

256: p_return_status OUT NOCOPY VARCHAR2 ,
257: p_msg_count OUT NOCOPY NUMBER ,
258: p_msg_data OUT NOCOPY VARCHAR2 ,
259: --
260: p_position_id IN psb_positions.position_id%TYPE,
261: p_worksheet_id IN NUMBER
262: )
263: IS
264: --

Line 268: l_data_extract_id psb_positions.data_extract_id%TYPE ;

264: --
265: l_api_name CONSTANT VARCHAR2(30):='Add_Position_To_Position_Sets';
266: l_api_version CONSTANT NUMBER := 1.0;
267: --
268: l_data_extract_id psb_positions.data_extract_id%TYPE ;
269: l_business_group_id psb_positions.data_extract_id%TYPE ;
270: l_match_found_in_set_flag VARCHAR2(1) ;
271: l_matching_attributes_count NUMBER ;
272: --

Line 269: l_business_group_id psb_positions.data_extract_id%TYPE ;

265: l_api_name CONSTANT VARCHAR2(30):='Add_Position_To_Position_Sets';
266: l_api_version CONSTANT NUMBER := 1.0;
267: --
268: l_data_extract_id psb_positions.data_extract_id%TYPE ;
269: l_business_group_id psb_positions.data_extract_id%TYPE ;
270: l_match_found_in_set_flag VARCHAR2(1) ;
271: l_matching_attributes_count NUMBER ;
272: --
273: BEGIN

Line 301: FROM psb_positions

297: business_group_id
298: INTO
299: l_data_extract_id ,
300: l_business_group_id
301: FROM psb_positions
302: WHERE position_id = p_position_id ;
303:
304: -- Scan all the position sets to check which one the position belongs to.
305: FOR l_set_rec IN

Line 615: FROM psb_positions

611:
612: FOR l_position_rec IN
613: (
614: SELECT position_id
615: FROM psb_positions
616: WHERE data_extract_id = l_data_extract_id
617: MINUS
618: SELECT position_id
619: FROM psb_position_assignments