APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_POSITIONS

Line 743: from PSB_POSITIONS a,

739: select 'Exists'
740: from dual
741: where exists
742: (select a.position_id, a.effective_start_date, a.effective_end_date, a.budget_group_id
743: from PSB_POSITIONS a,
744: (select budget_group_id from PSB_BUDGET_GROUPS
745: start with budget_group_id = g_budget_group_id
746: connect by prior budget_group_id = parent_budget_group_id) b
747: where a.data_extract_id = g_data_extract_id

Line 3200: from PSB_POSITIONS a,

3196: and account_or_position_type = 'A';
3197:
3198: cursor c_positions is
3199: select a.position_id, a.effective_start_date, a.effective_end_date, a.budget_group_id
3200: from PSB_POSITIONS a,
3201: (select budget_group_id from PSB_BUDGET_GROUPS
3202: start with budget_group_id = g_budget_group_id
3203: connect by prior budget_group_id = parent_budget_group_id) b
3204: where a.data_extract_id = p_data_extract_id

Line 4696: from PSB_POSITIONS

4692: where worksheet_id = p_budget_revision_id;
4693:
4694: cursor c_Positions is
4695: select *
4696: from PSB_POSITIONS
4697: where position_id = l_position_id;
4698:
4699: cursor c_pay_element_rates is
4700: select *

Line 4806: PSB_POSITIONS_PVT.Modify_Assignment

4802: end loop;
4803:
4804: for c_assignments_rec in c_assignments loop
4805:
4806: PSB_POSITIONS_PVT.Modify_Assignment
4807: (p_api_version => 1.0,
4808: p_return_status => l_return_status,
4809: p_msg_count => l_msg_count,
4810: p_msg_data => l_msg_data,

Line 4860: PSB_POSITIONS_PVT.UPDATE_ROW

4856: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4857: raise FND_API.G_EXC_ERROR;
4858: end if;
4859:
4860: PSB_POSITIONS_PVT.UPDATE_ROW
4861: (
4862: p_api_version => 1.0,
4863: p_init_msg_list => FND_API.G_FALSE,
4864: p_commit => FND_API.G_FALSE,

Line 6914: from PSB_POSITIONS

6910: select position_id,
6911: name,
6912: effective_start_date,
6913: effective_end_date
6914: from PSB_POSITIONS
6915: where position_id = p_position_id;
6916:
6917: cursor c_Element_Assignments is
6918: select worksheet_id,

Line 8321: from PSB_POSITIONS a,

8317: cursor c_SalaryNeqAll is
8318: select a.name position_name,
8319: b.name,
8320: b.grade_step
8321: from PSB_POSITIONS a,
8322: PSB_PAY_ELEMENT_OPTIONS b,
8323: PSB_POSITION_ASSIGNMENTS c
8324: where exists
8325: (select 1

Line 9015: PSB_POSITIONS c,

9011: select d.position_id,
9012: c.name
9013: from PSB_BUDGET_REVISION_POSITIONS a,
9014: PSB_BUDGET_REVISION_POS_LINES b,
9015: PSB_POSITIONS c,
9016: PSB_BUDGET_POSITIONS d,
9017: PSB_SET_RELATIONS e
9018: where a.budget_revision_pos_line_id = b.budget_revision_pos_line_id
9019: and b.budget_revision_id = p_budget_revision_id

Line 9692: FROM psb_positions pp

9688: /*For Bug No : 1527423 Start*/
9689: CURSOR l_br_pos_csr is
9690:
9691: SELECT position_id
9692: FROM psb_positions pp
9693: WHERE pp.data_extract_id = l_data_extract_id
9694: AND nvl(pp.new_position_flag, 'N') = 'Y'
9695: AND EXISTS (SELECT 1
9696: FROM psb_budget_revision_positions brp,

Line 9756: -- Delete from psb_positions

9752: --
9753: IF ( p_revise_by_position = 'Y' ) THEN
9754: --
9755: /*For Bug No ; 1527423 Start*/
9756: -- Delete from psb_positions
9757: FOR l_br_pos_csr_rec IN l_br_pos_csr LOOP
9758: DELETE psb_position_assignments
9759: WHERE position_id = l_br_pos_csr_rec.position_id;
9760:

Line 9761: DELETE psb_positions

9757: FOR l_br_pos_csr_rec IN l_br_pos_csr LOOP
9758: DELETE psb_position_assignments
9759: WHERE position_id = l_br_pos_csr_rec.position_id;
9760:
9761: DELETE psb_positions
9762: WHERE position_id = l_br_pos_csr_rec.position_id;
9763: END LOOP;
9764: /*For Bug No : 1527423 End*/
9765: