APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_BUDGET_REVISION_POSITIONS

Line 5410: from psb_budget_revision_positions brp, psb_budget_revision_pos_lines brpl

5406: select 'Exists'
5407: from dual
5408: where exists
5409: (select 'Exists'
5410: from psb_budget_revision_positions brp, psb_budget_revision_pos_lines brpl
5411: where brp.position_id = p_position_id
5412: and brpl.budget_revision_pos_line_id = brp.budget_revision_pos_line_id
5413: and brpl.budget_revision_id = p_source_id);
5414:

Line 8194: from psb_budget_revision_pos_lines brpl, psb_budget_revision_positions brp, psb_position_assignments ppa

8190: select 'Exists'
8191: from dual
8192: where exists
8193: (select 'Exists'
8194: from psb_budget_revision_pos_lines brpl, psb_budget_revision_positions brp, psb_position_assignments ppa
8195: where brpl.budget_revision_id = p_source_id
8196: and brp.budget_revision_pos_line_id = brpl.budget_revision_pos_line_id
8197: and ppa.position_id = brp.position_id
8198: and ppa.pay_element_id = p_element_id

Line 9477: psb_budget_revision_positions brp

9473: cursor c_revision_fte is
9474: select brp.position_id, brp.effective_start_date, brp.effective_end_date,
9475: brp.revision_type, brp.revision_value_type, brp.revision_value
9476: from psb_budget_revision_pos_lines brpl,
9477: psb_budget_revision_positions brp
9478: where brpl.budget_revision_id = p_source_id
9479: and brp.budget_revision_pos_line_id = brpl.budget_revision_pos_line_id;
9480:
9481: /* bug no 3670254 */