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 1780: gl_alc_ledger_rships_v rep, pa_implementations imp

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

Line 2584: gl_alc_ledger_rships_v rep, pa_implementations imp

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

Line 3446: gl_alc_ledger_rships_v rep, pa_implementations imp

3442: 0 projfunc_retn_amount,
3443: 0 funding_retn_amount,
3444: 0 inv_retn_amount
3445: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3446: gl_alc_ledger_rships_v rep, pa_implementations imp
3447: WHERE di.project_id = p_project_id
3448: AND di.agreement_id = p_agreement_id
3449: AND dii.project_id = di.project_id
3450: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3491: gl_alc_ledger_rships_v rep, pa_implementations imp

3487: 0 projfunc_retn_amount,
3488: 0 funding_retn_amount,
3489: 0 inv_retn_amount
3490: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3491: gl_alc_ledger_rships_v rep, pa_implementations imp
3492: WHERE di.project_id = p_project_id
3493: AND di.agreement_id = p_agreement_id
3494: AND dii.project_id = di.project_id
3495: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3742: gl_alc_ledger_rships_v rep, pa_implementations imp

3738: dii.funding_bill_amount,0)) funding_retn_amount,
3739: sum(decode(dii.invoice_line_type,'RETENTION',
3740: dii.inv_amount,0)) inv_retn_amount
3741: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3742: gl_alc_ledger_rships_v rep, pa_implementations imp
3743: WHERE di.project_id = p_project_id
3744: AND di.agreement_id = p_agreement_id
3745: AND dii.project_id = di.project_id
3746: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3787: gl_alc_ledger_rships_v rep, pa_implementations imp

3783: 0 projfunc_retn_amount,
3784: 0 funding_retn_amount,
3785: 0 inv_retn_amount
3786: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3787: gl_alc_ledger_rships_v rep, pa_implementations imp
3788: WHERE di.project_id = p_project_id
3789: AND di.agreement_id = p_agreement_id
3790: AND dii.project_id = di.project_id
3791: AND dii.draft_invoice_num = di.draft_invoice_num

Line 5910: gl_alc_ledger_rships_v rep, pa_implementations imp

5906: sum(dii_mc.amount) projfunc_bill_amount,
5907: sum(dii.funding_bill_amount) funding_bill_amount,
5908: sum(dii.inv_amount) inv_amount
5909: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,
5910: gl_alc_ledger_rships_v rep, pa_implementations imp
5911: WHERE dii.project_id = p_project_id
5912: AND dii.draft_invoice_num = p_draft_inv_num
5913: -- AND dii.invoice_line_type <> 'RETENTION'
5914: AND rep.source_ledger_id = imp.set_of_books_id

Line 6165: gl_alc_ledger_rships_v rep, pa_implementations imp

6161: SELECT RDL_MC.set_of_books_id,
6162: SUM((rdl.retained_amount/rdl.bill_amount) * rdl_mc.amount) retained_amt_pfc,
6163: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6164: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII, pa_mc_cust_rdl_all RDL_MC,
6165: gl_alc_ledger_rships_v rep, pa_implementations imp
6166: WHERE DII.project_id = p_project_id
6167: AND DII.draft_invoice_num = p_draft_inv_num
6168: AND NVL(DII.task_id,0) = p_task_id
6169: AND RDL.project_id = DII.project_id

Line 6216: gl_alc_ledger_rships_v rep, pa_implementations imp

6212: SUM((erdl.retained_amount/erdl.amount) * ERDL_MC.amount) retained_amt_pfc,
6213: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6214: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,
6215: pa_mc_cust_event_rdl_all ERDL_MC,
6216: gl_alc_ledger_rships_v rep, pa_implementations imp
6217: WHERE DII.project_id = p_project_id
6218: AND DII.draft_invoice_num = p_draft_inv_num
6219: AND NVL(DII.task_id,0) = p_task_id
6220: AND ERDL.project_id = DII.project_id

Line 6263: gl_alc_ledger_rships_v rep, pa_implementations imp

6259: SELECT DII_MC.set_of_books_id,
6260: SUM((DII.retained_amount/DII.amount) * DII_MC.amount) retained_amt_pfc,
6261: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6262: FROM pa_draft_invoice_items DII, pa_mc_draft_inv_items DII_MC,
6263: gl_alc_ledger_rships_v rep, pa_implementations imp
6264: WHERE DII.project_id = p_project_id
6265: AND DII.draft_invoice_num = p_draft_inv_num
6266: AND DII.task_id = p_task_id
6267: AND rep.source_ledger_id = imp.set_of_books_id

Line 7073: gl_alc_ledger_rships_v rep, pa_implementations imp

7069: sum(dii_mc.amount) projfunc_bill_amount,
7070: sum(dii.funding_bill_amount) funding_bill_amount
7071: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,
7072: pa_draft_invoices di,
7073: gl_alc_ledger_rships_v rep, pa_implementations imp
7074: WHERE di.project_id = p_project_id
7075: AND di.agreement_id = p_agreement_id
7076: AND dii.project_id = di.project_id
7077: AND dii.draft_invoice_num = di.draft_invoice_num

Line 7144: gl_alc_ledger_rships_v rep, pa_implementations imp

7140: sum(dii.amount) amount,
7141: sum(dii_mc.amount) projfunc_bill_amount,
7142: sum(dii.funding_bill_amount) funding_bill_amount
7143: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
7144: gl_alc_ledger_rships_v rep, pa_implementations imp
7145: WHERE di.project_id = p_project_id
7146: AND di.agreement_id = p_agreement_id
7147: AND dii.project_id = di.project_id
7148: AND dii.draft_invoice_num = di.draft_invoice_num

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

7870: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
7871:
7872: END IF;
7873:
7874: SELECT NVL(org_id,-99) INTO l_OrgId FROM PA_IMPLEMENTATIONS;
7875:
7876: l_FundingCurrencyCode := G_RevalCompTab(G_SET_OF_BOOKS_ID).funding_currency_code;
7877: l_ProjFuncCurrencyCode := G_RevalCompTab(G_SET_OF_BOOKS_ID).projfunc_currency_code;
7878: l_InvprocCurrencyCode := G_RevalCompTab(G_SET_OF_BOOKS_ID).Invproc_currency_code;