APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_BUDGET_REVISION_ACCOUNTS

Line 9447: psb_budget_revision_accounts b

9443: cursor c_revision_amount is
9444: select sum(decode(b.revision_type, 'I', b.revision_amount,
9445: 'D', -b.revision_amount)) revision_amount
9446: from psb_budget_revision_lines a,
9447: psb_budget_revision_accounts b
9448: where a.budget_revision_id = p_source_id
9449: and b.budget_revision_acct_line_id = a.budget_revision_acct_line_id
9450: and b.position_id is not null;
9451:

Line 10896: psb_budget_revision_accounts b,

10892: cursor c_position_cost_br (positionid NUMBER) is
10893: select sum(decode(b.revision_type, 'I', b.revision_amount,
10894: 'D', -b.revision_amount)) revision_amount
10895: from psb_budget_revision_lines a,
10896: psb_budget_revision_accounts b,
10897: psb_positions pp
10898: where a.budget_revision_id = p_source_id
10899: and b.budget_revision_acct_line_id = a.budget_revision_acct_line_id
10900: and pp.position_id = b.position_id