APPS.ARP_RECON_REP dependencies on GL_SETS_OF_BOOKS

Line 445: FROM gl_sets_of_books sob

441: INTO l_sob_name,
442: l_sob_id,
443: l_functional_currency,
444: l_coa_id
445: FROM gl_sets_of_books sob
446: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
447:
448: ELSIF p_reporting_level = 3000 THEN
449: SELECT sob.name sob_name,

Line 457: FROM gl_sets_of_books sob,

453: INTO l_sob_name,
454: l_sob_id,
455: l_functional_currency,
456: l_coa_id
457: FROM gl_sets_of_books sob,
458: ar_system_parameters_all sysparam
459: WHERE sob.set_of_books_id = sysparam.set_of_books_id
460: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
461:

Line 955: FROM gl_sets_of_books sob

951: INTO l_sob_name,
952: l_sob_id,
953: l_functional_currency,
954: l_coa_id
955: FROM gl_sets_of_books sob
956: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
957:
958: ELSIF p_reporting_level = 3000 THEN
959: SELECT sob.name sob_name,

Line 967: FROM gl_sets_of_books sob,

963: INTO l_sob_name,
964: l_sob_id,
965: l_functional_currency,
966: l_coa_id
967: FROM gl_sets_of_books sob,
968: ar_system_parameters_all sysparam
969: WHERE sob.set_of_books_id = sysparam.set_of_books_id
970: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
971:

Line 1542: FROM gl_sets_of_books sob

1538: INTO l_sob_name,
1539: l_sob_id,
1540: l_functional_currency,
1541: l_coa_id
1542: FROM gl_sets_of_books sob
1543: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1544:
1545: ELSIF p_reporting_level = 3000 THEN
1546: SELECT sob.name sob_name,

Line 1554: FROM gl_sets_of_books sob,

1550: INTO l_sob_name,
1551: l_sob_id,
1552: l_functional_currency,
1553: l_coa_id
1554: FROM gl_sets_of_books sob,
1555: ar_system_parameters_all sysparam
1556: WHERE sob.set_of_books_id = sysparam.set_of_books_id
1557: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1558:

Line 2054: FROM gl_sets_of_books sob

2050: INTO l_sob_name,
2051: l_sob_id,
2052: l_functional_currency,
2053: l_coa_id
2054: FROM gl_sets_of_books sob
2055: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2056:
2057: ELSIF p_reporting_level = 3000 THEN
2058: SELECT sob.name sob_name,

Line 2066: FROM gl_sets_of_books sob,

2062: INTO l_sob_name,
2063: l_sob_id,
2064: l_functional_currency,
2065: l_coa_id
2066: FROM gl_sets_of_books sob,
2067: ar_system_parameters_all sysparam
2068: WHERE sob.set_of_books_id = sysparam.set_of_books_id
2069: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2070:

Line 2638: FROM gl_sets_of_books sob

2634: SELECT sob.name sob_name,
2635: sob.currency_code functional_currency
2636: INTO l_sob_name,
2637: l_functional_currency
2638: FROM gl_sets_of_books sob
2639: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2640:
2641: ELSIF p_reporting_level = 3000 THEN
2642: SELECT sob.name sob_name,

Line 2646: FROM gl_sets_of_books sob,

2642: SELECT sob.name sob_name,
2643: sob.currency_code functional_currency
2644: INTO l_sob_name,
2645: l_functional_currency
2646: FROM gl_sets_of_books sob,
2647: ar_system_parameters_all sysparam
2648: WHERE sob.set_of_books_id = sysparam.set_of_books_id
2649: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2650:

Line 2663: FROM gl_periods p, gl_sets_of_books b

2659: from dual;
2660: /* Get the period start and end dates */
2661: SELECT p.start_date, p.end_date
2662: INTO l_gl_date_from , l_gl_date_to
2663: FROM gl_periods p, gl_sets_of_books b
2664: WHERE p.period_set_name = b.period_set_name
2665: AND p.period_type = b.accounted_period_type
2666: AND b.set_of_books_id = arp_recon_rep.var_tname.g_set_of_books_id
2667: AND p.period_name = arp_recon_rep.var_tname.g_period_name;