25: x_assign_id number;
26:
27: cursor c1 is
28: select 1
29: from sys.dual
30: where exists (select prc_assignment_id
31: from pa_mc_exp_items_all
32: where prc_assignment_id = x_assignment_id);
33:
34: c1_rec c1%rowtype;
35:
36: cursor c2 is
37: select 1
38: from sys.dual
39: where exists (select prc_assignment_id
40: from pa_mc_cost_dist_lines_all
41: where prc_assignment_id = x_assignment_id);
42:
43: c2_rec c2%rowtype;
44:
45: cursor c3 is
46: select 1
47: from sys.dual
48: where exists (select prc_assignment_id
49: from pa_mc_cust_rdl_all
50: where prc_assignment_id = x_assignment_id);
51:
52: c3_rec c3%rowtype;
53:
54: cursor c4 is
55: select 1
56: from sys.dual
57: where exists (select prc_assignment_id
58: from pa_mc_cust_event_rdl_all
59: where prc_assignment_id = x_assignment_id);
60:
61: c4_rec c4%rowtype;
62:
63: cursor c5 is
64: select 1
65: from sys.dual
66: where exists (select prc_assignment_id
67: from pa_mc_events
68: where prc_assignment_id = x_assignment_id);
69:
70: c5_rec c5%rowtype;
71: /*
72: cursor c6 is
73: select 1
74: from sys.dual
75: where exists (select prc_assignment_id
76: from pa_mc_budget_lines
77: where prc_assignment_id = x_assignment_id);
78:
79: c6_rec c6%rowtype;
80:
81: cursor c7 is
82: select 1
83: from sys.dual
84: where exists (select prc_assignment_id
85: from pa_mc_commitment_txns
86: where prc_assignment_id = x_assignment_id);
87: