APPS.PSB_WS_POS3 dependencies on PSB_POSITIONS

Line 532: from PSB_POSITIONS pp

528: l_flex_code NUMBER;
529:
530: cursor c_Positions is
531: select pp.position_id, pp.name
532: from PSB_POSITIONS pp
533: where pp.data_extract_id = l_data_extract_id
534: and exists
535: (select 1
536: from PSB_POSITION_ASSIGNMENTS pa,

Line 2139: PSB_POSITIONS c

2135: select a.position_id,
2136: c.name
2137: from PSB_BUDGET_POSITIONS a,
2138: PSB_SET_RELATIONS b,
2139: PSB_POSITIONS c
2140: where a.data_extract_id = p_data_extract_id
2141: and a.account_position_set_id = b.account_position_set_id
2142: and b.parameter_id = p_parameter_id
2143: and c.position_id = a.position_id;

Line 2491: PSB_POSITIONS_PVT.Modify_Assignment

2487: end if;
2488:
2489: l_element_value_type := c_Formula_Rec.element_value_type;
2490:
2491: PSB_POSITIONS_PVT.Modify_Assignment
2492: (p_api_version => 1.0,
2493: p_return_status => l_return_status,
2494: p_msg_count => l_msg_count,
2495: p_msg_data => l_msg_data,

Line 2530: PSB_POSITIONS_PVT.Modify_Assignment

2526:
2527: l_element_value := c_Formula_Rec.element_value;
2528: l_element_value_type := c_Formula_Rec.element_value_type;
2529:
2530: PSB_POSITIONS_PVT.Modify_Assignment
2531: (p_api_version => 1.0,
2532: p_return_status => l_return_status,
2533: p_msg_count => l_msg_count,
2534: p_msg_data => l_msg_data,

Line 2569: PSB_POSITIONS_PVT.Modify_Assignment

2565: end;
2566: elsif c_Formula_Rec.assignment_type = 'ATTRIBUTE' then
2567: begin
2568:
2569: PSB_POSITIONS_PVT.Modify_Assignment
2570: (p_api_version => 1.0,
2571: p_return_status => l_return_status,
2572: p_msg_count => l_msg_count,
2573: p_msg_data => l_msg_data,

Line 2759: PSB_POSITIONS_PVT.Modify_Assignment

2755:
2756: end;
2757: end if;
2758:
2759: PSB_POSITIONS_PVT.Modify_Assignment
2760: (p_api_version => 1.0,
2761: p_return_status => l_return_status,
2762: p_msg_count => l_msg_count,
2763: p_msg_data => l_msg_data,

Line 2828: PSB_POSITIONS_PVT.Modify_Assignment

2824:
2825: end;
2826: end if;
2827:
2828: PSB_POSITIONS_PVT.Modify_Assignment
2829: (p_api_version => 1.0,
2830: p_return_status => l_return_status,
2831: p_msg_count => l_msg_count,
2832: p_msg_data => l_msg_data,

Line 3331: PSB_POSITIONS_PVT.Modify_Assignment

3327: else
3328: l_element_value := c_ElemRates_Rec.element_value + p_increment_by;
3329: end if;
3330:
3331: PSB_POSITIONS_PVT.Modify_Assignment
3332: (p_api_version => 1.0,
3333: p_return_status => l_return_status,
3334: p_msg_count => l_msg_count,
3335: p_msg_data => l_msg_data,

Line 3381: PSB_POSITIONS_PVT.Modify_Assignment

3377: else
3378: l_element_value := c_Elem_Rec.element_value + p_increment_by;
3379: end if;
3380:
3381: PSB_POSITIONS_PVT.Modify_Assignment
3382: (p_api_version => 1.0,
3383: p_return_status => l_return_status,
3384: p_msg_count => l_msg_count,
3385: p_msg_data => l_msg_data,

Line 3472: PSB_POSITIONS_PVT.Modify_Assignment

3468:
3469: end;
3470: end if;
3471:
3472: PSB_POSITIONS_PVT.Modify_Assignment
3473: (p_api_version => 1.0,
3474: p_return_status => l_return_status,
3475: p_msg_count => l_msg_count,
3476: p_msg_data => l_msg_data,

Line 3562: PSB_POSITIONS_PVT.Modify_Assignment

3558:
3559: end;
3560: end if;
3561:
3562: PSB_POSITIONS_PVT.Modify_Assignment
3563: (p_api_version => 1.0,
3564: p_return_status => l_return_status,
3565: p_msg_count => l_msg_count,
3566: p_msg_data => l_msg_data,

Line 3640: PSB_POSITIONS_PVT.Modify_Assignment

3636: if not FND_API.to_Boolean(l_nextrate_found) then
3637: l_pay_element_option_id := c_Elem_Rec.pay_element_option_id;
3638: end if;
3639:
3640: PSB_POSITIONS_PVT.Modify_Assignment
3641: (p_api_version => 1.0,
3642: p_return_status => l_return_status,
3643: p_msg_count => l_msg_count,
3644: p_msg_data => l_msg_data,

Line 3772: from PSB_POSITIONS a,

3768: cursor c_Positions is
3769: select a.position_id,
3770: a.effective_start_date,
3771: a.effective_end_date
3772: from PSB_POSITIONS a,
3773: PSB_WS_POSITION_LINES b
3774: where a.position_id = b.position_id
3775: and b.position_line_id = p_position_line_id;
3776:

Line 4668: PSB_POSITIONS_PVT.Modify_Assignment

4664: begin
4665:
4666: for c_Positions_Rec in c_Positions loop
4667:
4668: PSB_POSITIONS_PVT.Modify_Assignment
4669: (p_api_version => 1.0,
4670: p_return_status => l_return_status,
4671: p_msg_count => l_msg_count,
4672: p_msg_data => l_msg_data,

Line 4976: PSB_POSITIONS c,

4972: c.name,
4973: a.position_line_id
4974: from PSB_WS_LINES_POSITIONS a,
4975: PSB_WS_POSITION_LINES b,
4976: PSB_POSITIONS c,
4977: PSB_BUDGET_POSITIONS d,
4978: PSB_SET_RELATIONS e
4979: where a.position_line_id = b.position_line_id
4980: and a.worksheet_id = p_worksheet_id

Line 5251: from PSB_POSITIONS a,

5247: cursor c_SalaryNeqAll is
5248: select a.name position_name,
5249: b.name,
5250: b.grade_step
5251: from PSB_POSITIONS a,
5252: PSB_PAY_ELEMENT_OPTIONS b,
5253: PSB_POSITION_ASSIGNMENTS c
5254: where exists
5255: (select 1