eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_UTILS2 dependencies on PA_PROJECTS_ALL

Line 116: from pa_projects_all pp

112: AND pkt.document_type = 'PO'
113: AND (( pkt.expenditure_type = p_expenditure_type
114: and p_line_type = 'BURDEN'
115: and EXISTS (select null
116: from pa_projects_all pp
117: ,pa_project_types_all pt
118: where pt.project_type = pp.project_type
119: and pt.org_id = pp.org_id /*5368274*/
120: and pp.project_id = pkt.project_id

Line 127: from pa_projects_all pp

123: OR
124: (p_line_type = 'RAW'
125: and pkt.parent_bc_packet_id is NULL
126: and EXISTS (select null
127: from pa_projects_all pp
128: ,pa_project_types_all pt
129: where pt.project_type = pp.project_type
130: and pt.org_id = pp.org_id /*5368274*/
131: and pp.project_id = pkt.project_id

Line 136: from pa_projects_all pp

132: and NVL(pt.burden_amt_display_method,'N') = 'D'
133: ))
134: OR
135: (EXISTS (select null
136: from pa_projects_all pp
137: ,pa_project_types_all pt
138: where pt.project_type = pp.project_type
139: and pt.org_id = pp.org_id /*5368274*/
140: and pp.project_id = pkt.project_id

Line 163: from pa_projects_all pp

159: AND NVL(com.summary_record_flag,'N') = 'Y'
160: AND (( com.expenditure_type = p_expenditure_type
161: and p_line_type = 'BURDEN'
162: and EXISTS (select null
163: from pa_projects_all pp
164: ,pa_project_types_all pt
165: where pt.project_type = pp.project_type
166: and pt.org_id = pp.org_id /*5368274*/
167: and pp.project_id = com.project_id

Line 174: from pa_projects_all pp

170: OR
171: (p_line_type = 'RAW'
172: and com.parent_bc_packet_id is NULL
173: and EXISTS (select null
174: from pa_projects_all pp
175: ,pa_project_types_all pt
176: where pt.project_type = pp.project_type
177: and pt.org_id = pp.org_id /*5368274*/
178: and pp.project_id = com.project_id

Line 183: from pa_projects_all pp

179: and NVL(pt.burden_amt_display_method,'N') = 'D'
180: ))
181: OR
182: (EXISTS (select null
183: from pa_projects_all pp
184: ,pa_project_types_all pt
185: where pt.project_type = pp.project_type
186: and pt.org_id = pp.org_id /*5368274*/
187: and pp.project_id = com.project_id

Line 343: ,pa_projects_all pp

339:
340: CURSOR cur_comsumRecInfo (p_project_id Number,p_task_id Number,p_doc_line_id Number ) IS
341: SELECT sm.expenditure_type
342: FROM pa_bc_commitments_all sm
343: ,pa_projects_all pp
344: ,pa_project_types_all pt
345: WHERE sm.summary_record_flag = 'Y'
346: AND sm.project_id = p_project_id
347: AND sm.task_id = p_task_id

Line 359: ,pa_projects_all pp

355:
356: CURSOR cur_pktsumRecInfo(p_project_id Number,p_task_id Number,p_doc_line_id Number ) IS
357: SELECT sm.expenditure_type
358: FROM pa_bc_packets sm
359: ,pa_projects_all pp
360: ,pa_project_types_all pt
361: WHERE sm.summary_record_flag = 'Y'
362: AND sm.project_id = p_project_id
363: AND sm.task_id = p_task_id