APPS.PA_TRX_IMPORT dependencies on PA_IMPLEMENTATIONS_ALL

Line 147: G_SobId pa_implementations_all.set_of_books_id%TYPE;

143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
146: G_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
147: G_SobId pa_implementations_all.set_of_books_id%TYPE;
148: G_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;
149: -- G_FSIO_ENABLED varchar2(1); --FSIO Changes
150:
151: Prev_SobId NUMBER;

Line 148: G_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;

144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
146: G_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
147: G_SobId pa_implementations_all.set_of_books_id%TYPE;
148: G_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;
149: -- G_FSIO_ENABLED varchar2(1); --FSIO Changes
150:
151: Prev_SobId NUMBER;
152: Prev_OrgID NUMBER;

Line 1532: l_SobId pa_implementations_all.set_of_books_id%TYPE; -- bug 3357936

1528:
1529: --Bug 3010848
1530: L_Org_RetSts Varchar2(50);
1531:
1532: l_SobId pa_implementations_all.set_of_books_id%TYPE; -- bug 3357936
1533: l_appl_id NUMBER(15) := PA_PERIOD_PROCESS_PKG.Application_Id; -- bug 3357936
1534:
1535: -- Start of Changes for Bug 5743708
1536: x_cp_structure VARCHAR2(30);

Line 4016: from pa_implementations_all

4012: IF G_gl_posted_flag = 'N' AND X_gl_date IS NULL THEN
4013:
4014: select set_of_books_id
4015: into l_SobId
4016: from pa_implementations_all
4017: where nvl(org_id,-99) = nvl(X_org_id,-99);
4018:
4019: X_gl_date := pa_utils2.get_prvdr_gl_date( X_ei_date, l_appl_id , l_SobId) ;
4020:

Line 4365: from pa_implementations_all

4361: END IF;
4362:
4363: select set_of_books_id
4364: into G_SobId
4365: from pa_implementations_all
4366: where org_id = X_org_id;
4367:
4368: Prev_SobId := G_SobId;
4369: Prev_OrgID := X_Org_Id;

Line 4398: from pa_implementations_all

4394: END IF;
4395:
4396: select set_of_books_id
4397: into G_RecvrSobId
4398: from pa_implementations_all
4399: where org_id = nvl(G_RecvrOrgId,-99);
4400:
4401: Prev_RecvrSobId := G_RecvrSobId;
4402: Prev_RecvrOrgID := G_RecvrOrgId;

Line 7270: FROM gl_sets_of_books glb, pa_implementations_all pai

7266: -- Determine cash Based accounting flag
7267:
7268: SELECT NVL(glb.sla_ledger_cash_basis_flag,'N')
7269: INTO G_cash_based_accounting
7270: FROM gl_sets_of_books glb, pa_implementations_all pai
7271: WHERE glb.set_of_books_id = pai.set_of_books_id
7272: AND pai.org_id = g_moac_org_id ;
7273:
7274: /** Bug#3026218 There will be only two fetches - from TrxRecs1 and TRxRecs2