APPS.PA_TRX_IMPORT dependencies on GL_SETS_OF_BOOKS

Line 1243: ,gl_sets_of_books sob

1239: where code_combination_id = ccid
1240: and enabled_flag='Y'
1241: and chart_of_accounts_id in (select sob.chart_of_accounts_id
1242: from pa_implementations imp
1243: ,gl_sets_of_books sob
1244: where imp.set_of_books_id=sob.set_of_books_id) ; /*10138679*/
1245:
1246: G_PrevCCID := ccid;
1247: G_PrevRetVal := 1;

Line 4817: -- FROM gl_sets_of_books

4813:
4814: --IF (nvl(Prev_SobId,-101) <> nvl(G_SobId,-99)) THEN
4815: -- SELECT NVL(sla_ledger_cash_basis_flag,'N')
4816: -- INTO G_cash_based_accounting
4817: -- FROM gl_sets_of_books
4818: -- WHERE set_of_books_id = G_SobId;
4819: --
4820: --END IF;
4821:

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