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 97: from pa_projects_all pp

93: AND pkt.document_type = 'PO'
94: AND (( pkt.expenditure_type = p_expenditure_type
95: and p_line_type = 'BURDEN'
96: and EXISTS (select null
97: from pa_projects_all pp
98: ,pa_project_types_all pt
99: where pt.project_type = pp.project_type
100: and pt.org_id = pp.org_id /*5368274*/
101: and pp.project_id = pkt.project_id

Line 108: from pa_projects_all pp

104: OR
105: (p_line_type = 'RAW'
106: and pkt.parent_bc_packet_id is NULL
107: and EXISTS (select null
108: from pa_projects_all pp
109: ,pa_project_types_all pt
110: where pt.project_type = pp.project_type
111: and pt.org_id = pp.org_id /*5368274*/
112: and pp.project_id = pkt.project_id

Line 117: from pa_projects_all pp

113: and NVL(pt.burden_amt_display_method,'N') = 'D'
114: ))
115: OR
116: (EXISTS (select null
117: from pa_projects_all pp
118: ,pa_project_types_all pt
119: where pt.project_type = pp.project_type
120: and pt.org_id = pp.org_id /*5368274*/
121: and pp.project_id = pkt.project_id

Line 144: from pa_projects_all pp

140: AND NVL(com.summary_record_flag,'N') = 'Y'
141: AND (( com.expenditure_type = p_expenditure_type
142: and p_line_type = 'BURDEN'
143: and EXISTS (select null
144: from pa_projects_all pp
145: ,pa_project_types_all pt
146: where pt.project_type = pp.project_type
147: and pt.org_id = pp.org_id /*5368274*/
148: and pp.project_id = com.project_id

Line 155: from pa_projects_all pp

151: OR
152: (p_line_type = 'RAW'
153: and com.parent_bc_packet_id is NULL
154: and EXISTS (select null
155: from pa_projects_all pp
156: ,pa_project_types_all pt
157: where pt.project_type = pp.project_type
158: and pt.org_id = pp.org_id /*5368274*/
159: and pp.project_id = com.project_id

Line 164: from pa_projects_all pp

160: and NVL(pt.burden_amt_display_method,'N') = 'D'
161: ))
162: OR
163: (EXISTS (select null
164: from pa_projects_all pp
165: ,pa_project_types_all pt
166: where pt.project_type = pp.project_type
167: and pt.org_id = pp.org_id /*5368274*/
168: and pp.project_id = com.project_id

Line 321: ,pa_projects_all pp

317:
318: CURSOR cur_comsumRecInfo (p_project_id Number,p_task_id Number,p_doc_line_id Number ) IS
319: SELECT sm.expenditure_type
320: FROM pa_bc_commitments_all sm
321: ,pa_projects_all pp
322: ,pa_project_types_all pt
323: WHERE sm.summary_record_flag = 'Y'
324: AND sm.project_id = p_project_id
325: AND sm.task_id = p_task_id

Line 337: ,pa_projects_all pp

333:
334: CURSOR cur_pktsumRecInfo(p_project_id Number,p_task_id Number,p_doc_line_id Number ) IS
335: SELECT sm.expenditure_type
336: FROM pa_bc_packets sm
337: ,pa_projects_all pp
338: ,pa_project_types_all pt
339: WHERE sm.summary_record_flag = 'Y'
340: AND sm.project_id = p_project_id
341: AND sm.task_id = p_task_id