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 1645: l_SobId pa_implementations_all.set_of_books_id%TYPE; -- bug 3357936

1641:
1642: --Bug 3010848
1643: L_Org_RetSts Varchar2(50);
1644:
1645: l_SobId pa_implementations_all.set_of_books_id%TYPE; -- bug 3357936
1646: l_appl_id NUMBER(15) := PA_PERIOD_PROCESS_PKG.Application_Id; -- bug 3357936
1647:
1648: -- Start of Changes for Bug 5743708
1649: x_cp_structure VARCHAR2(30);

Line 1859: FROM pa_implementations_all

1855: /* Started Bug 16451280 */
1856: l_all_neg_acc := NULL;
1857: SELECT NVL(allow_negative_accrual, 'N')
1858: INTO l_all_neg_acc
1859: FROM pa_implementations_all
1860: WHERE org_id = X_org_id;
1861:
1862: /* END Bug 16451280 */
1863:

Line 4446: from pa_implementations_all

4442: IF G_gl_posted_flag = 'N' AND X_gl_date IS NULL THEN
4443:
4444: select set_of_books_id
4445: into l_SobId
4446: from pa_implementations_all
4447: where nvl(org_id,-99) = nvl(X_org_id,-99);
4448:
4449: X_gl_date := pa_utils2.get_prvdr_gl_date( X_ei_date, l_appl_id , l_SobId) ;
4450:

Line 4799: from pa_implementations_all

4795: END IF;
4796:
4797: select set_of_books_id
4798: into G_SobId
4799: from pa_implementations_all
4800: where org_id = X_org_id;
4801:
4802: Prev_SobId := G_SobId;
4803: Prev_OrgID := X_Org_Id;

Line 4832: from pa_implementations_all

4828: END IF;
4829:
4830: select set_of_books_id
4831: into G_RecvrSobId
4832: from pa_implementations_all
4833: where org_id = nvl(G_RecvrOrgId,-99);
4834:
4835: Prev_RecvrSobId := G_RecvrSobId;
4836: Prev_RecvrOrgID := G_RecvrOrgId;

Line 7891: FROM gl_sets_of_books glb, pa_implementations_all pai

7887: -- Determine cash Based accounting flag
7888:
7889: SELECT NVL(glb.sla_ledger_cash_basis_flag,'N')
7890: INTO G_cash_based_accounting
7891: FROM gl_sets_of_books glb, pa_implementations_all pai
7892: WHERE glb.set_of_books_id = pai.set_of_books_id
7893: AND pai.org_id = g_moac_org_id ;
7894:
7895: /** Bug#3026218 There will be only two fetches - from TrxRecs1 and TRxRecs2