APPS.PA_MC_CURRENCY_PKG dependencies on PA_IMPLEMENTATIONS

Line 62: pa_implementations_all i

58:
59: SELECT gl.currency_code
60: INTO currency
61: FROM gl_sets_of_books gl,
62: pa_implementations_all i
63: -- WHERE NVL(i.org_id,-99) = NVL(x_org_id,-99)
64: WHERE i.org_id = x_org_id -- x_org_id also taken from Implementation table.
65: AND i.set_of_books_id = gl.set_of_books_id;
66:

Line 96: FROM pa_implementations_all i

92: G_PREV_ORG_ID2 := x_org_id;
93:
94: SELECT set_of_books_id
95: INTO sob_id
96: FROM pa_implementations_all i
97: -- WHERE NVL(i.org_id,-99) = NVL(x_org_id,-99);
98: where i.org_id = x_org_id ;
99:
100: G_PREV_SOB_ID := sob_id;

Line 117: /* This function returns SOB id from pa_implementations

113: FUNCTION set_of_books RETURN NUMBER
114: IS
115: sob_id NUMBER;
116:
117: /* This function returns SOB id from pa_implementations
118: Hence, no Org info needed */
119:
120: BEGIN
121:

Line 124: FROM pa_implementations;

120: BEGIN
121:
122: SELECT set_of_books_id
123: INTO sob_id
124: FROM pa_implementations;
125:
126: RETURN sob_id;
127:
128: EXCEPTION WHEN OTHERS THEN

Line 158: PA_Implementations */

154: FUNCTION get_mrc_sob_type_code RETURN VARCHAR2
155: IS
156: sob_type VARCHAR2(1);
157: /* Returns MRC_SOB_TYPE_CODE for the SOB from
158: PA_Implementations */
159:
160: BEGIN
161: SELECT mrc_sob_type_code
162: INTO sob_type

Line 164: pa_implementations imp

160: BEGIN
161: SELECT mrc_sob_type_code
162: INTO sob_type
163: FROM gl_sets_of_books gl,
164: pa_implementations imp
165: WHERE gl.set_of_books_id = imp.set_of_books_id;
166:
167: RETURN sob_type;
168:

Line 1377: -- pa_implementations imp -- Fix for Perf Bug 2695336

1373:
1374: SELECT sum(nvl(rdl.amount,0))
1375: INTO rdl_amt
1376: FROM pa_mc_cust_rdl_all rdl
1377: -- pa_implementations imp -- Fix for Perf Bug 2695336
1378: WHERE rdl.project_id = x_project_id
1379: AND rdl.draft_revenue_num = x_draft_revenue_num
1380: AND rdl.draft_revenue_item_line_num = x_draft_revenue_item_line_num
1381: AND rdl.set_of_books_id = NVL(TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO'), 45,10) ), -99);

Line 1388: -- pa_implementations imp -- Fix for Perf Bug 2695336

1384: SELECT sum(nvl(erdl.amount,0))
1385: INTO erdl_amt
1386: FROM pa_mc_cust_event_rdl_all erdl,
1387: pa_cust_event_rdl_all cerdl
1388: -- pa_implementations imp -- Fix for Perf Bug 2695336
1389: WHERE cerdl.project_id = x_project_id
1390: AND cerdl.draft_revenue_num = x_draft_revenue_num
1391: AND cerdl.draft_revenue_item_line_num = x_draft_revenue_item_line_num
1392: AND erdl.set_of_books_id = NVL(TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO'), 45,10) ), -99)

Line 1622: from pa_implementations;

1618: PAAPIMP_PKG.G_err_stage := 'GET ORG_ID IN INS_MC_TXN_INTERFACE';
1619: --select NVL(org_id,-99)
1620: select org_id
1621: into l_org_id
1622: from pa_implementations;
1623:
1624: /**
1625:
1626: PAAPIMP_PKG.G_err_stage := 'CALLING FUNCTIONAL_CURRENCY IN INS_MC_TXN_INTERFACE';