DBA Data[Home] [Help]

APPS.PSB_GL_INTERFACE_PVT dependencies on PSB_SET_RELATIONS

Line 2112: psb_set_relations vs,

2108: CURSOR c_bgversion
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

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 ' ||