APPS.PSB_GL_INTERFACE_PVT dependencies on PSB_GL_BUDGETS

Line 932: FROM PSB_GL_BUDGETS

928:
929: CURSOR c_budver
930: IS
931: SELECT gl_budget_version_id
932: FROM PSB_GL_BUDGETS
933: WHERE gl_budget_set_id = p_gl_budget_set_id
934: AND p_year_start_date BETWEEN start_date AND end_date;
935:
936: CURSOR c_bud_name(gl_budver_id NUMBER)

Line 2113: psb_gl_budgets vgb

2109: IS
2110: SELECT gl_budget_version_id
2111: FROM psb_budget_accounts v,
2112: psb_set_relations vs,
2113: psb_gl_budgets vgb
2114: WHERE vgb.gl_budget_set_id = p_gl_budget_set_id
2115: AND vgb.gl_budget_id = vs.gl_budget_id
2116: AND v.code_combination_id = l_code_combination_id
2117: AND vs.account_position_set_id = v.account_position_set_id

Line 2744: FROM psb_GL_BUDGETS

2740: SELECT 'Y'
2741: FROM dual
2742: WHERE EXISTS
2743: (SELECT 1
2744: FROM psb_GL_BUDGETS
2745: WHERE dual_posting_type = 'A'
2746: AND gl_budget_set_id = p_gl_budget_set_id
2747: AND start_date BETWEEN l_year_start_date AND l_year_end_date
2748: );

Line 3223: 'FROM PSB_BUDGET_ACCOUNTS v, PSB_SET_RELATIONS vs, PSB_GL_BUDGETS vgb ' ||

3219: --- 'minus ' ||
3220: 'AND NOT exists (' ||
3221: /* Bug No 1357416 END */
3222: 'SELECT v.code_combination_id ' ||
3223: 'FROM PSB_BUDGET_ACCOUNTS v, PSB_SET_RELATIONS vs, PSB_GL_BUDGETS vgb ' ||
3224: 'WHERE :start_date BETWEEN vgb.start_date AND vgb.end_date ' ||
3225: 'AND vgb.gl_budget_set_id = :gl_budget_set_id ' ||
3226: 'AND vgb.gl_budget_id = vs.gl_budget_id ' ||
3227: 'AND vs.account_position_set_id = v.account_position_set_id ' ||

Line 3262: 'FROM PSB_BUDGET_ACCOUNTS v, PSB_SET_RELATIONS vs, PSB_GL_BUDGETS vgb ' ||

3258: --- 'minus ' ||
3259: 'AND NOT exists (' ||
3260: /* Bug No 1357416 END */
3261: 'SELECT v.code_combination_id ' ||
3262: 'FROM PSB_BUDGET_ACCOUNTS v, PSB_SET_RELATIONS vs, PSB_GL_BUDGETS vgb ' ||
3263: 'WHERE :start_date BETWEEN vgb.start_date AND vgb.end_date ' ||
3264: 'AND vgb.gl_budget_set_id = :gl_budget_set_id ' ||
3265: 'AND vgb.gl_budget_id = vs.gl_budget_id ' ||
3266: 'AND vs.account_position_set_id = v.account_position_set_id ' ||

Line 3411: psb_gl_budgets pgb

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
3414: AND br.budget_revision_type = 'R'
3415: -- Bug 3029168 added the following OR condition