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 98: ,pa_project_types_all pt

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

Line 109: ,pa_project_types_all pt

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

Line 118: ,pa_project_types_all pt

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

Line 145: ,pa_project_types_all pt

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

Line 156: ,pa_project_types_all pt

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

Line 165: ,pa_project_types_all pt

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

Line 322: ,pa_project_types_all pt

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

Line 338: ,pa_project_types_all pt

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