eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUND_REVAL_PVT dependencies on PA_IMPLEMENTATIONS

Line 474: FROM gl_mc_reporting_options rep, pa_implementations imp

470: new table gl_alc_ledger_rships_v and corresponding columns */
471:
472: /* CURSOR rsob is SELECT rep.reporting_set_of_books_id reporting_set_of_books_id ,
473: rep.reporting_currency_code, rep.conversion_type
474: FROM gl_mc_reporting_options rep, pa_implementations imp
475: WHERE rep.primary_set_of_books_id = imp.set_of_books_id
476: AND enabled_flag = 'Y'
477: AND rep.org_id = imp.org_id
478: AND application_id = 275; */

Line 483: FROM gl_alc_ledger_rships_v rep, pa_implementations imp

479:
480: CURSOR rsob is SELECT rep.ledger_id reporting_set_of_books_id ,
481: rep.currency_code reporting_currency_code,
482: rep.alc_default_conv_rate_type conversion_type
483: FROM gl_alc_ledger_rships_v rep, pa_implementations imp
484: WHERE rep.source_ledger_id = imp.set_of_books_id
485: AND rep.relationship_enabled_flag = 'Y'
486: AND (rep.org_id = -99 OR rep.org_id = imp.org_id)
487: AND rep.application_id = 275;

Line 501: FROM gl_mc_reporting_options rep, pa_implementations imp

497:
498:
499: /* CURSOR rsob_ar_mc is SELECT rep.reporting_set_of_books_id reporting_set_of_books_id ,
500: rep.reporting_currency_code, rep.conversion_type
501: FROM gl_mc_reporting_options rep, pa_implementations imp
502: WHERE rep.primary_set_of_books_id = imp.set_of_books_id
503: AND enabled_flag = 'Y'
504: AND rep.org_id = imp.org_id
505: AND application_id = PA_FUND_REVAL_UTIL.get_ar_application_id; */

Line 511: FROM gl_alc_ledger_rships_v rep, pa_implementations imp

507:
508: CURSOR rsob_ar_mc is SELECT rep.ledger_id reporting_set_of_books_id ,
509: rep.currency_code reporting_currency_code,
510: rep.alc_default_conv_rate_type conversion_type
511: FROM gl_alc_ledger_rships_v rep, pa_implementations imp
512: WHERE rep.source_ledger_id = imp.set_of_books_id
513: AND rep.relationship_enabled_flag = 'Y'
514: AND (rep.org_id = -99 OR rep.org_id = imp.org_id)
515: AND application_id = PA_FUND_REVAL_UTIL.get_ar_application_id;

Line 544: into G_SET_OF_BOOKS_ID, G_MRC_FUND_ENABLED_FLAG FROM pa_implementations;

540: /* Gets primary set of book id and MRC funding enabled flag */
541:
542: /*
543: SELECT set_of_books_id, nvl(ENABLE_MRC_FOR_FUND_FLAG , 'N')
544: into G_SET_OF_BOOKS_ID, G_MRC_FUND_ENABLED_FLAG FROM pa_implementations;
545: */
546:
547: SELECT set_of_books_id, 'N' -- nvl(REVAL_MRC_FUNDING_FLAG , 'N')
548: into G_SET_OF_BOOKS_ID, G_MRC_FUND_ENABLED_FLAG FROM pa_implementations;

Line 548: into G_SET_OF_BOOKS_ID, G_MRC_FUND_ENABLED_FLAG FROM pa_implementations;

544: into G_SET_OF_BOOKS_ID, G_MRC_FUND_ENABLED_FLAG FROM pa_implementations;
545: */
546:
547: SELECT set_of_books_id, 'N' -- nvl(REVAL_MRC_FUNDING_FLAG , 'N')
548: into G_SET_OF_BOOKS_ID, G_MRC_FUND_ENABLED_FLAG FROM pa_implementations;
549:
550: /* Global Flag indicating if AR module is installed */
551: G_AR_INSTALLED_FLAG := get_ar_installed;
552:

Line 1782: gl_alc_ledger_rships_v rep, pa_implementations imp

1778: PC.retention_level_code retention_level_code,
1779: PC.customer_id cust_id
1780: FROM pa_mc_sum_proj_fundings SPF_mc, pa_summary_project_fundings SPF,
1781: pa_agreements_all A, pa_project_customers PC,
1782: gl_alc_ledger_rships_v rep, pa_implementations imp
1783: WHERE SPF.project_id = l_ProjectId
1784: AND A.agreement_id = SPF.agreement_id
1785: AND PC.customer_id = A.customer_id
1786: AND PC.project_id = SPF.project_id

Line 2586: gl_alc_ledger_rships_v rep, pa_implementations imp

2582: sum(dii_mc.amount) projfunc_bill_amount,
2583: sum(dii.funding_bill_amount) funding_bill_amount,
2584: sum(dii.inv_amount) inv_amount
2585: FROM pa_draft_invoice_items dii, pa_mc_draft_inv_items dii_mc, pa_draft_invoices di,
2586: gl_alc_ledger_rships_v rep, pa_implementations imp
2587: WHERE di.project_id = p_project_id
2588: AND di.agreement_id = p_agreement_id
2589: AND di.transfer_status_code = 'A'
2590: AND dii.project_id = di.project_id

Line 3450: gl_alc_ledger_rships_v rep, pa_implementations imp

3446: 0 projfunc_retn_amount,
3447: 0 funding_retn_amount,
3448: 0 inv_retn_amount
3449: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3450: gl_alc_ledger_rships_v rep, pa_implementations imp
3451: WHERE di.project_id = p_project_id
3452: AND di.agreement_id = p_agreement_id
3453: AND dii.project_id = di.project_id
3454: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3495: gl_alc_ledger_rships_v rep, pa_implementations imp

3491: 0 projfunc_retn_amount,
3492: 0 funding_retn_amount,
3493: 0 inv_retn_amount
3494: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3495: gl_alc_ledger_rships_v rep, pa_implementations imp
3496: WHERE di.project_id = p_project_id
3497: AND di.agreement_id = p_agreement_id
3498: AND dii.project_id = di.project_id
3499: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3748: gl_alc_ledger_rships_v rep, pa_implementations imp

3744: dii.funding_bill_amount,0)) funding_retn_amount,
3745: sum(decode(dii.invoice_line_type,'RETENTION',
3746: dii.inv_amount,0)) inv_retn_amount
3747: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3748: gl_alc_ledger_rships_v rep, pa_implementations imp
3749: WHERE di.project_id = p_project_id
3750: AND di.agreement_id = p_agreement_id
3751: AND dii.project_id = di.project_id
3752: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3793: gl_alc_ledger_rships_v rep, pa_implementations imp

3789: 0 projfunc_retn_amount,
3790: 0 funding_retn_amount,
3791: 0 inv_retn_amount
3792: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3793: gl_alc_ledger_rships_v rep, pa_implementations imp
3794: WHERE di.project_id = p_project_id
3795: AND di.agreement_id = p_agreement_id
3796: AND dii.project_id = di.project_id
3797: AND dii.draft_invoice_num = di.draft_invoice_num

Line 5919: gl_alc_ledger_rships_v rep, pa_implementations imp

5915: sum(dii_mc.amount) projfunc_bill_amount,
5916: sum(dii.funding_bill_amount) funding_bill_amount,
5917: sum(dii.inv_amount) inv_amount
5918: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,
5919: gl_alc_ledger_rships_v rep, pa_implementations imp
5920: WHERE dii.project_id = p_project_id
5921: AND dii.draft_invoice_num = p_draft_inv_num
5922: -- AND dii.invoice_line_type <> 'RETENTION'
5923: AND rep.source_ledger_id = imp.set_of_books_id

Line 6178: gl_alc_ledger_rships_v rep, pa_implementations imp

6174: SELECT RDL_MC.set_of_books_id,
6175: SUM((rdl.retained_amount/rdl.bill_amount) * rdl_mc.amount) retained_amt_pfc,
6176: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6177: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII, pa_mc_cust_rdl_all RDL_MC,
6178: gl_alc_ledger_rships_v rep, pa_implementations imp
6179: WHERE DII.project_id = p_project_id
6180: AND DII.draft_invoice_num = p_draft_inv_num
6181: AND NVL(DII.task_id,0) = p_task_id
6182: AND RDL.project_id = DII.project_id

Line 6233: gl_alc_ledger_rships_v rep, pa_implementations imp

6229: SUM((erdl.retained_amount/erdl.amount) * ERDL_MC.amount) retained_amt_pfc,
6230: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6231: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,
6232: pa_mc_cust_event_rdl_all ERDL_MC,
6233: gl_alc_ledger_rships_v rep, pa_implementations imp
6234: WHERE DII.project_id = p_project_id
6235: AND DII.draft_invoice_num = p_draft_inv_num
6236: AND NVL(DII.task_id,0) = p_task_id
6237: AND ERDL.project_id = DII.project_id

Line 6283: gl_alc_ledger_rships_v rep, pa_implementations imp

6279: SELECT DII_MC.set_of_books_id,
6280: SUM((DII.retained_amount/DII.amount) * DII_MC.amount) retained_amt_pfc,
6281: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6282: FROM pa_draft_invoice_items DII, pa_mc_draft_inv_items DII_MC,
6283: gl_alc_ledger_rships_v rep, pa_implementations imp
6284: WHERE DII.project_id = p_project_id
6285: AND DII.draft_invoice_num = p_draft_inv_num
6286: AND DII.task_id = p_task_id
6287: AND rep.source_ledger_id = imp.set_of_books_id

Line 7094: gl_alc_ledger_rships_v rep, pa_implementations imp

7090: sum(dii_mc.amount) projfunc_bill_amount,
7091: sum(dii.funding_bill_amount) funding_bill_amount
7092: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,
7093: pa_draft_invoices di,
7094: gl_alc_ledger_rships_v rep, pa_implementations imp
7095: WHERE di.project_id = p_project_id
7096: AND di.agreement_id = p_agreement_id
7097: AND dii.project_id = di.project_id
7098: AND dii.draft_invoice_num = di.draft_invoice_num

Line 7166: gl_alc_ledger_rships_v rep, pa_implementations imp

7162: sum(dii.amount) amount,
7163: sum(dii_mc.amount) projfunc_bill_amount,
7164: sum(dii.funding_bill_amount) funding_bill_amount
7165: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
7166: gl_alc_ledger_rships_v rep, pa_implementations imp
7167: WHERE di.project_id = p_project_id
7168: AND di.agreement_id = p_agreement_id
7169: AND dii.project_id = di.project_id
7170: AND dii.draft_invoice_num = di.draft_invoice_num

Line 7897: SELECT NVL(org_id,-99) INTO l_OrgId FROM PA_IMPLEMENTATIONS;

7893: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
7894:
7895: END IF;
7896:
7897: SELECT NVL(org_id,-99) INTO l_OrgId FROM PA_IMPLEMENTATIONS;
7898:
7899: l_FundingCurrencyCode := G_RevalCompTab(G_SET_OF_BOOKS_ID).funding_currency_code;
7900: l_ProjFuncCurrencyCode := G_RevalCompTab(G_SET_OF_BOOKS_ID).projfunc_currency_code;
7901: l_InvprocCurrencyCode := G_RevalCompTab(G_SET_OF_BOOKS_ID).Invproc_currency_code;