APPS.GL_AUTO_ALLOC_WF_PKG dependencies on GL_AUTO_ALLOC_REV_BATCHES

Line 1731: FROM GL_AUTO_ALLOC_REV_BATCHES RB

1727: Select JE.JE_HEADER_ID
1728: FROM GL_JE_HEADERS JE
1729: WHERE JE.JE_BATCH_ID = l_gen_batch_id
1730: AND NOT EXISTS ( SELECT RB.JE_HEADER_ID
1731: FROM GL_AUTO_ALLOC_REV_BATCHES RB
1732: WHERE RB.PARENT_REQUEST_ID = to_number(p_item_key)
1733: AND RB.JE_HEADER_ID = JE.JE_HEADER_ID);
1734:
1735: Begin

Line 1924: ,GL_AUTO_ALLOC_REV_BATCHES R

1920:
1921: Cursor verify_rev_batch_C IS
1922: Select R.REVERSAL_JE_HEADER_ID
1923: From GL_JE_BATCHES JEB
1924: ,GL_AUTO_ALLOC_REV_BATCHES R
1925: Where JEB.JE_BATCH_ID = R.REVERSAL_JE_BATCH_ID
1926: AND JEB.STATUS Not In ('P','I')
1927: AND R.PARENT_REQUEST_ID = to_number(p_item_key);
1928:

Line 2088: ,GL_AUTO_ALLOC_REV_BATCHES GLAARV

2084: GLAARV.REVERSAL_JE_BATCH_ID
2085: ,BH.step_Number
2086: FROM GL_JE_BATCHES GLB
2087: ,GL_AUTO_ALLOC_BATCH_HISTORY BH
2088: ,GL_AUTO_ALLOC_REV_BATCHES GLAARV
2089: Where GLB.JE_BATCH_ID = GLAARV.REVERSAL_JE_BATCH_ID
2090: AND GLAARV.JE_BATCH_ID = BH.GENERATED_JE_BATCH_ID
2091: AND GLB.STATUS NOT In ('P','I','S')
2092: AND BH.REQUEST_ID = to_number(p_item_key)

Line 2210: ,GL_AUTO_ALLOC_REV_BATCHES RB

2206: ,JEB.JE_Batch_Id
2207: ,BH.Step_Number
2208: From GL_JE_BATCHES JEB
2209: ,GL_AUTO_ALLOC_BATCH_HISTORY BH
2210: ,GL_AUTO_ALLOC_REV_BATCHES RB
2211: Where JEB.JE_BATCH_ID = RB.REVERSAL_JE_BATCH_ID
2212: And RB.JE_BATCH_ID = BH.GENERATED_JE_BATCH_ID
2213: AND BH.REQUEST_ID = to_number(p_item_key)
2214: And RB.PARENT_REQUEST_ID = to_number(p_item_key);

Line 2614: ,GL_AUTO_ALLOC_REV_BATCHES GLAARV

2610: Set Posting_Run_Id = l_posting_run_id
2611: ,Status = 'S'
2612: Where JE_BATCH_ID in ( Select GLAARV.REVERSAL_JE_BATCH_ID
2613: From GL_JE_BATCHES GLB
2614: ,GL_AUTO_ALLOC_REV_BATCHES GLAARV
2615: Where GLB.JE_BATCH_ID = GLAARV.REVERSAL_JE_BATCH_ID
2616: AND GLB.STATUS NOT In ('P','I','S')
2617: AND GLAARV.PARENT_REQUEST_ID = to_number(p_item_key) );
2618: