DBA Data[Home] [Help]

APPS.PSB_WORKSHEET dependencies on PSB_ALLOCRULE_ASSIGNMENTS_V

Line 275: from PSB_ALLOCRULE_ASSIGNMENTS_V

271:
272: cursor c_ar1 is
273: select Count(*) count_ar1,
274: Max(last_update_date) lud_ar1
275: from PSB_ALLOCRULE_ASSIGNMENTS_V
276: where allocrule_set_id = p_allocrule_set_id;
277:
278: cursor c_ar2 is
279: select Count(*) count_ar2,

Line 284: from PSB_ALLOCRULE_ASSIGNMENTS_V

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);
286:
287: cursor c_bc is
288: select Count(*) count_bc,