APPS.PA_PRC_PROJECT_PUB dependencies on DUAL

Line 29: from sys.dual

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:

Line 38: from sys.dual

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:

Line 47: from sys.dual

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:

Line 56: from sys.dual

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:

Line 65: from sys.dual

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:

Line 74: from sys.dual

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:

Line 83: from sys.dual

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: