APPS.PSB_GL_INTERFACE_PVT dependencies on PSB_BUDGET_REVISION_LINES

Line 3253: 'FROM psb_budget_revision_accounts bra, psb_budget_revision_lines brl ' ||

3249: ELSIF p_event_type = 'BR' OR p_event_type = 'SR' THEN -- Bug 3029168
3250: BEGIN
3251: OPEN fb_cv FOR
3252: 'SELECT bra.code_combination_id ' ||
3253: 'FROM psb_budget_revision_accounts bra, psb_budget_revision_lines brl ' ||
3254: 'WHERE brl.budget_revision_id = :source_id ' ||
3255: l_curr_string|| -- Bug 3029168
3256: 'AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id ' ||
3257: /* Bug No 1357416 Start */

Line 3409: psb_budget_revision_lines brl,

3405: ) cr_amount,
3406: budget_balance x_amount
3407: FROM psb_budget_revisions br,
3408: psb_budget_revision_accounts bra,
3409: psb_budget_revision_lines brl,
3410: gl_period_statuses gps,
3411: psb_gl_budgets pgb
3412: WHERE br.budget_revision_id = p_budget_revision_id
3413: AND brl.budget_revision_id = p_budget_revision_id

Line 3721: FROM psb_budget_revision_lines

3717: FROM PSB_BUDGET_REVISION_ACCOUNTS ac,
3718: GL_PERIOD_STATUSES gp
3719: WHERE ac.budget_revision_acct_line_id IN
3720: (SELECT budget_revision_acct_line_id
3721: FROM psb_budget_revision_lines
3722: WHERE budget_revision_id = p_budget_revision_id
3723: )
3724: AND ac.gl_period_name = gp.period_name
3725: AND gp.application_id = 101