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_REVERSE_COSTED_LAB dependencies on PA_EXPENDITURES

Line 188: pa_expenditures exp

184: ,item.interface_run_id interface_run_id
185: ,'Y' reverse_eligibile_flag
186: ,NULL reverse_error_code
187: FROM pa_expenditure_items item,
188: pa_expenditures exp
189: WHERE exp.expenditure_id = item.expenditure_id
190: AND exp.expenditure_status_code = 'APPROVED'
191: AND (item.cost_distributed_flag = 'Y' OR (item.cost_distributed_flag = 'N'
192: AND item.costing_method IS NOT NULL

Line 214: pa_expenditures exp

210: ,item.interface_run_id interface_run_id
211: ,uncosted_eis_exist(NVL(P_cost_set,item.interface_run_id), NVL(P_inc_by_person_id,exp.incurred_by_person_id)) reverse_eligibile_flag -- returns X if exists
212: ,NULL reverse_error_code
213: FROM pa_expenditure_items item,
214: pa_expenditures exp
215: WHERE exp.expenditure_id = item.expenditure_id
216: AND exp.expenditure_status_code = 'APPROVED'
217: AND item.system_linkage_function IN ('ST','OT','PJ','BTC')
218: AND NVL(item.net_zero_adjustment_flag,'N') <> 'Y'

Line 241: pa_expenditures exp

237: CURSOR c_uncosted_costset (x_empid NUMBER, x_costset_id NUMBER)
238: IS
239: SELECT ei.expenditure_item_id
240: FROM pa_expenditure_items ei,
241: pa_expenditures exp
242: WHERE ei.expenditure_id = exp.expenditure_id
243: AND ei.interface_run_id = x_costset_id
244: AND exp.incurred_by_person_id = x_empid
245: AND ei.cost_distributed_flag='N';

Line 250: PA_EXPENDITURES EXP1

246:
247: CURSOR c_block_backout (x_empid NUMBER, x_costset_id NUMBER) IS
248: SELECT EI1.EXPENDITURE_ITEM_ID
249: FROM PA_EXPENDITURE_ITEMS EI1,
250: PA_EXPENDITURES EXP1
251: WHERE EXP1.INCURRED_BY_PERSON_ID = X_EMPID
252: AND EI1.EXPENDITURE_ID = EXP1.EXPENDITURE_ID
253: AND EI1.INTERFACE_RUN_ID = x_costset_id
254: AND EI1.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'

Line 260: PA_EXPENDITURES EXP2

256: (
257: SELECT EI2.EXPENDITURE_ITEM_ID
258: FROM PA_EXPENDITURE_ITEMS EI3,
259: PA_EXPENDITURE_ITEMS EI2,
260: PA_EXPENDITURES EXP2
261: WHERE EI3.interface_run_id = EI1.INTERFACE_RUN_ID
262: AND SUBSTR(EI2.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1) =
263: SUBSTR(EI3.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1)
264: AND EXP2.INCURRED_BY_PERSON_ID = X_EMPID

Line 276: PA_EXPENDITURES EXP4

272: /* adjustment is not by PAXREVTXN reversal process but from OTL */
273: SELECT EI4.EXPENDITURE_ITEM_ID
274: FROM PA_EXPENDITURE_ITEMS EI5 ,
275: PA_EXPENDITURE_ITEMS EI4 ,
276: PA_EXPENDITURES EXP4
277: WHERE EI5.interface_run_id = EI1.INTERFACE_RUN_ID
278: AND EXP4.INCURRED_BY_PERSON_ID = X_EMPID
279: AND EXP4.EXPENDITURE_ID = EI4.EXPENDITURE_ID
280: AND EI4.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'

Line 309: l_temp_emp_id pa_expenditures.incurred_by_person_id%TYPE := -1;

305: l_temp_num_processed NUMBER := 500;
306: temp_status NUMBER DEFAULT NULL;
307: l_status VARCHAR2(10) := NULL;
308: l_result NUMBER;
309: l_temp_emp_id pa_expenditures.incurred_by_person_id%TYPE := -1;
310: l_Exp_item_id_tb2 PA_PLSQL_DATATYPES.IdTabTyp;
311: l_Exp_item_id_tb3 PA_PLSQL_DATATYPES.IdTabTyp; --Bug12779047
312: l_temp_interface_run_id pa_expenditure_items.interface_run_id%TYPE :=-1;
313: -- =======================================================================

Line 753: pa_expenditures exp

749:
750: SELECT COUNT(1)
751: INTO l_count
752: FROM pa_expenditure_items item,
753: pa_expenditures exp
754: WHERE exp.expenditure_id = item.expenditure_id
755: AND (exp.incurred_by_person_id =P_incurred_by_person_id
756: AND item.interface_run_id =P_interface_run_id)
757: AND item.cost_distributed_flag = 'N';

Line 764: PA_EXPENDITURES EXP1

760: -- Added for bug 12779047
761: SELECT Count(EI1.EXPENDITURE_ITEM_ID)
762: INTO l_count2 /*Changed variable from l_count to l_count2 for bug:12915699 */
763: FROM PA_EXPENDITURE_ITEMS EI1,
764: PA_EXPENDITURES EXP1
765: WHERE EXP1.INCURRED_BY_PERSON_ID = P_incurred_by_person_id
766: AND EI1.EXPENDITURE_ID = EXP1.EXPENDITURE_ID
767: AND EI1.INTERFACE_RUN_ID = P_interface_run_id
768: AND EI1.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'

Line 774: PA_EXPENDITURES EXP2

770: (
771: SELECT EI2.EXPENDITURE_ITEM_ID
772: FROM PA_EXPENDITURE_ITEMS EI3,
773: PA_EXPENDITURE_ITEMS EI2,
774: PA_EXPENDITURES EXP2
775: WHERE EI3.interface_run_id = EI1.INTERFACE_RUN_ID
776: AND SUBSTR(EI2.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1) =
777: SUBSTR(EI3.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1)
778: AND EXP2.INCURRED_BY_PERSON_ID = P_incurred_by_person_id

Line 790: PA_EXPENDITURES EXP4

786: /* adjustment is not by PAXREVTXN reversal process but from OTL */
787: SELECT EI4.EXPENDITURE_ITEM_ID
788: FROM PA_EXPENDITURE_ITEMS EI5 ,
789: PA_EXPENDITURE_ITEMS EI4 ,
790: PA_EXPENDITURES EXP4
791: WHERE EI5.interface_run_id = EI1.INTERFACE_RUN_ID
792: AND EXP4.INCURRED_BY_PERSON_ID = P_incurred_by_person_id
793: AND EXP4.EXPENDITURE_ID = EI4.EXPENDITURE_ID
794: AND EI4.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'