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_PROJECT_TYPES_ALL

Line 117: ,pa_project_types_all pt

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
121: and NVL(pt.burden_amt_display_method,'N') = 'D'

Line 128: ,pa_project_types_all pt

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
132: and NVL(pt.burden_amt_display_method,'N') = 'D'

Line 137: ,pa_project_types_all pt

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
141: and NVL(pt.burden_amt_display_method,'N') <> 'D'

Line 164: ,pa_project_types_all pt

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
168: and NVL(pt.burden_amt_display_method,'N') = 'D'

Line 175: ,pa_project_types_all pt

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
179: and NVL(pt.burden_amt_display_method,'N') = 'D'

Line 184: ,pa_project_types_all pt

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
188: and NVL(pt.burden_amt_display_method,'N') <> 'D'

Line 344: ,pa_project_types_all pt

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
348: AND sm.document_line_id = p_doc_line_id

Line 360: ,pa_project_types_all pt

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
364: AND sm.document_line_id = p_doc_line_id