DBA Data[Home] [Help]

APPS.PSB_WORKSHEET dependencies on PSB_SET_RELATIONS

Line 236: from PSB_SET_RELATIONS

232:
233: cursor c_glset2 is
234: select Count(*) count_glset2,
235: Max(last_update_date) lud_glset2
236: from PSB_SET_RELATIONS
237: where gl_budget_id in
238: (select gl_budget_id
239: from PSB_GL_BUDGETS
240: where gl_budget_set_id = p_gl_budget_set_id);

Line 251: from PSB_SET_RELATIONS

247:
248: cursor c_ps2 is
249: select Count(*) count_ps2,
250: Max(last_update_date) lud_ps2
251: from PSB_SET_RELATIONS
252: where parameter_id in
253: (select parameter_id
254: from PSB_PARAMETER_ASSIGNMENTS_V
255: where parameter_set_id = p_parameter_set_id);

Line 266: from PSB_SET_RELATIONS

262:
263: cursor c_cs2 is
264: select Count(*) count_cs2,
265: Max(last_update_date) lud_cs2
266: from PSB_SET_RELATIONS
267: where constraint_id in
268: (select constraint_id
269: from PSB_CONSTRAINT_ASSIGNMENTS_V
270: where constraint_set_id = p_constraint_set_id);

Line 281: from PSB_SET_RELATIONS

277:
278: cursor c_ar2 is
279: select Count(*) count_ar2,
280: Max(last_update_date) lud_ar2
281: from PSB_SET_RELATIONS
282: where allocation_rule_id in
283: (select allocrule_id
284: from PSB_ALLOCRULE_ASSIGNMENTS_V
285: where allocrule_set_id = p_allocrule_set_id);

Line 307: from PSB_SET_RELATIONS

303:
304: cursor c_bg2 is
305: select Count(*) count_bg2,
306: Max(last_update_date) lud_bg2
307: from PSB_SET_RELATIONS
308: where budget_group_id in
309: (select budget_group_id
310: from PSB_BUDGET_GROUPS
311: where budget_group_type = 'R'