APPS.PA_MULTI_CURRENCY_TXN dependencies on PA_UTILS2

Line 90: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_recvr.org_id))) PROJECT_RATE_DATE

86: ,NVL(x_project_rate_type,
87: NVL(proj.project_rate_type,imp_recvr.default_rate_type)) PROJECT_RATE_TYPE
88: ,NVL(proj.project_rate_date,DECODE(imp_recvr.default_rate_date_code,
89: 'E', P_EI_date, 'P'
90: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_recvr.org_id))) PROJECT_RATE_DATE
91: ,NVL(x_acct_rate_type, imp_prvdr.default_rate_type) ACCT_RATE_TYPE
92: ,NVL(x_acct_rate_date,DECODE(imp_prvdr.default_rate_date_code,
93: 'E', P_EI_date, 'P'
94: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_prvdr.org_id))) ACCT_RATE_DATE

Line 94: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_prvdr.org_id))) ACCT_RATE_DATE

90: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_recvr.org_id))) PROJECT_RATE_DATE
91: ,NVL(x_acct_rate_type, imp_prvdr.default_rate_type) ACCT_RATE_TYPE
92: ,NVL(x_acct_rate_date,DECODE(imp_prvdr.default_rate_date_code,
93: 'E', P_EI_date, 'P'
94: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_prvdr.org_id))) ACCT_RATE_DATE
95: ,proj.projfunc_currency_code PROJFUNC_CURRENCY_CODE
96: ,NVL(x_projfunc_cost_rate_type,
97: NVL( proj.projfunc_cost_rate_type,imp_recvr.default_rate_type)) PROJFUNC_COST_RATE_TYPE
98: ,NVL(proj.projfunc_cost_rate_date, DECODE(imp_prvdr.default_rate_date_code,

Line 100: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_prvdr.org_id))) PROJFUNC_COST_RATE_DATE

96: ,NVL(x_projfunc_cost_rate_type,
97: NVL( proj.projfunc_cost_rate_type,imp_recvr.default_rate_type)) PROJFUNC_COST_RATE_TYPE
98: ,NVL(proj.projfunc_cost_rate_date, DECODE(imp_prvdr.default_rate_date_code,
99: 'E', P_EI_date, 'P'
100: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_prvdr.org_id))) PROJFUNC_COST_RATE_DATE
101: FROM pa_projects_all proj
102: ,pa_implementations_all imp_prvdr
103: ,pa_implementations_all imp_recvr /* bug fix :2322364 */
104: WHERE proj.project_id = P_project_id

Line 428: pa_utils2.get_pa_date(P_EI_date,

424: SELECT NVL(NVL(task.taskfunc_cost_rate_date,
425: proj.projfunc_cost_rate_date),
426: DECODE(imp.default_rate_date_code,
427: 'E', P_EI_date, 'P',
428: pa_utils2.get_pa_date(P_EI_date,
429: sysdate, imp.org_id))) /**CBGA**/
430: INTO P_projfunc_cost_rate_date
431: FROM pa_projects_all proj,
432: pa_tasks task,

Line 454: pa_utils2.get_pa_date(P_EI_date,

450: THEN
451: SELECT NVL(proj.projfunc_cost_rate_date,
452: DECODE(imp.default_rate_date_code,
453: 'E', P_EI_date, 'P',
454: pa_utils2.get_pa_date(P_EI_date,
455: sysdate, imp.org_id)))
456: INTO P_projfunc_cost_rate_date
457: FROM pa_projects_all proj
458: ,pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all

Line 588: pa_utils2.get_pa_date(P_EI_date,

584: -- is P then return the PA period ending date.
585:
586: SELECT NVL(P_acct_rate_date,DECODE(default_rate_date_code,
587: 'E', P_EI_date, 'P',
588: pa_utils2.get_pa_date(P_EI_date,
589: sysdate, org_id))) /**CBGA**/
590: INTO P_acct_rate_date
591: FROM pa_implementations ;
592:

Line 2336: pa_utils2.get_pa_date(P_EI_date,

2332: SELECT NVL(NVL(task.project_rate_date,
2333: proj.project_rate_date),
2334: DECODE(imp.default_rate_date_code,
2335: 'E', P_EI_date, 'P',
2336: pa_utils2.get_pa_date(P_EI_date,
2337: sysdate, imp.org_id))) /**CBGA**/
2338: INTO P_project_rate_date
2339: FROM pa_projects_all proj,
2340: pa_tasks task,

Line 2363: pa_utils2.get_pa_date(P_EI_date,

2359: THEN
2360: SELECT NVL(proj.project_rate_date,
2361: DECODE(imp.default_rate_date_code,
2362: 'E', P_EI_date, 'P',
2363: pa_utils2.get_pa_date(P_EI_date,
2364: sysdate, imp.org_id)))
2365: INTO P_project_rate_date
2366: FROM pa_projects_all proj
2367: ,pa_implementations_all imp