APPS.PA_XLA_SWEEP_TXN_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 41: Procedure SWEEP_TXNS (P_ORG_ID PA_IMPLEMENTATIONS_ALL.ORG_ID%TYPE,

37:
38: END Log_Message;
39:
40:
41: Procedure SWEEP_TXNS (P_ORG_ID PA_IMPLEMENTATIONS_ALL.ORG_ID%TYPE,
42: P_GL_PERIOD GL_PERIOD_STATUSES.PERIOD_NAME%TYPE,
43: P_TRAN_TYPE VARCHAR2)
44: Is
45:

Line 107: from pa_implementations_all where org_id = g_org_id;

103: End If;
104:
105: Select set_of_books_id
106: into g_sob_id
107: from pa_implementations_all where org_id = g_org_id;
108:
109: Select START_DATE, End_Date into p_first_date , p_last_date
110: From gl_period_statuses
111: where period_name = P_GL_PERIOD

Line 281: PA_IMPLEMENTATIONS_ALL IMP ,

277: ei.expenditure_type ,
278: cdl.Acct_Event_ID
279: From PA_Cost_Distribution_lines_ALL CDL,
280: PA_Expenditure_items_all EI,
281: PA_IMPLEMENTATIONS_ALL IMP ,
282: PA_EXPENDITURES_ALL EXP ,
283: PA_EXPENDITURE_GROUPS_ALL EXP_GRP
284: Where CDL.Transfer_Status_Code = 'X'
285: AND CDL.expenditure_item_id = EI.expenditure_item_id