eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_BUDGET_POSITIONS

Line 5926: PSB_BUDGET_POSITIONS d

5922: a.segment29, a.segment30, a.effective_start_date, a.effective_end_date
5923: from PSB_PAY_ELEMENT_DISTRIBUTIONS a,
5924: PSB_ELEMENT_POS_SET_GROUPS b,
5925: PSB_SET_RELATIONS c,
5926: PSB_BUDGET_POSITIONS d
5927: where a.chart_of_accounts_id = g_flex_code
5928: and (((a.effective_start_date <= p_revision_end_date)
5929: and (a.effective_end_date is null))
5930: or ((a.effective_start_date between p_revision_start_date and p_revision_end_date)

Line 6242: PSB_BUDGET_POSITIONS d

6238: a.distribution_percent, a.effective_start_date, a.effective_end_date
6239: from PSB_PAY_ELEMENT_DISTRIBUTIONS a,
6240: PSB_ELEMENT_POS_SET_GROUPS b,
6241: PSB_SET_RELATIONS c,
6242: PSB_BUDGET_POSITIONS d
6243: where a.chart_of_accounts_id = g_flex_code
6244: and (((a.effective_start_date <= p_revision_end_date)
6245: and (a.effective_end_date is null))
6246: or ((a.effective_start_date between p_revision_start_date and p_revision_end_date)

Line 8326: from PSB_BUDGET_POSITIONS d,

8322: PSB_PAY_ELEMENT_OPTIONS b,
8323: PSB_POSITION_ASSIGNMENTS c
8324: where exists
8325: (select 1
8326: from PSB_BUDGET_POSITIONS d,
8327: PSB_SET_RELATIONS e
8328: where d.data_extract_id = g_data_extract_id
8329: and d.position_id = c.position_id
8330: and d.account_position_set_id = e.account_position_set_id

Line 8355: PSB_BUDGET_POSITIONS e,

8351: where exists
8352: (select 1
8353: from PSB_BUDGET_REVISION_POSITIONS c,
8354: PSB_BUDGET_REVISION_POS_LINES d,
8355: PSB_BUDGET_POSITIONS e,
8356: PSB_SET_RELATIONS f
8357: where d.budget_revision_id = a.budget_revision_id
8358: and c.budget_revision_pos_line_id = d.budget_revision_pos_line_id
8359: and d.budget_revision_id = p_budget_revision_id

Line 8376: PSB_BUDGET_POSITIONS f,

8372: where exists
8373: (select 1
8374: from PSB_BUDGET_REVISION_POSITIONS d,
8375: PSB_BUDGET_REVISION_POS_LINES e,
8376: PSB_BUDGET_POSITIONS f,
8377: PSB_SET_RELATIONS g
8378: where e.budget_revision_id = a.budget_revision_id
8379: and d.budget_revision_pos_line_id = e.budget_revision_pos_line_id
8380: and e.budget_revision_id = p_budget_revision_id

Line 8836: PSB_BUDGET_POSITIONS e,

8832: where exists
8833: (select 1
8834: from PSB_BUDGET_REVISION_POSITIONS c,
8835: PSB_BUDGET_REVISION_POS_LINES d,
8836: PSB_BUDGET_POSITIONS e,
8837: PSB_SET_RELATIONS f
8838: where c.budget_revision_pos_line_id = d.budget_revision_pos_line_id
8839: and d.budget_revision_id = p_budget_revision_id
8840: and c.position_id = e.position_id

Line 9016: PSB_BUDGET_POSITIONS d,

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
9020: and a.position_id = c.position_id