APPS.PA_XLA_SWEEP_TXN_PKG dependencies on GL_PERIOD_STATUSES

Line 42: P_GL_PERIOD GL_PERIOD_STATUSES.PERIOD_NAME%TYPE,

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:
46: Cursor ACC_EVENT_ERROR(p_start_date date, p_end_date date)

Line 110: From gl_period_statuses

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
112: and set_of_books_id = g_sob_id
113: and application_id = g_app_id ;
114:

Line 619: FROM gl_period_statuses GPS

615: log_message ('Deriving Next Period for Reversing EI');
616:
617: SELECT GPS.start_date
618: INTO l_prvdr_accr_date
619: FROM gl_period_statuses GPS
620: WHERE GPS.application_id = 101
621: AND GPS.set_of_books_id = g_sob_id
622: AND GPS.adjustment_period_flag = 'N'
623: AND GPS.start_date = (SELECT min(GPS1.start_date)

Line 624: FROM gl_period_statuses GPS1

620: WHERE GPS.application_id = 101
621: AND GPS.set_of_books_id = g_sob_id
622: AND GPS.adjustment_period_flag = 'N'
623: AND GPS.start_date = (SELECT min(GPS1.start_date)
624: FROM gl_period_statuses GPS1
625: WHERE GPS1.application_id = 101
626: AND GPS1.set_of_books_id = g_sob_id
627: AND GPS1.adjustment_period_flag = 'N'
628: AND GPS1.start_date > g_gl_date_new_tab(g_currec)