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 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 971: FROM gl_sets_of_books sob

967: INTO l_sob_name,
968: l_sob_id,
969: l_functional_currency,
970: l_coa_id
971: FROM gl_sets_of_books sob
972: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
973:
974: ELSIF p_reporting_level = 3000 THEN
975: SELECT sob.name sob_name,

Line 983: FROM gl_sets_of_books sob,

979: INTO l_sob_name,
980: l_sob_id,
981: l_functional_currency,
982: l_coa_id
983: FROM gl_sets_of_books sob,
984: ar_system_parameters sysparam
985: WHERE sob.set_of_books_id = sysparam.set_of_books_id
986: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
987:

Line 2182: FROM gl_sets_of_books sob

2178: INTO l_sob_name,
2179: l_sob_id,
2180: l_functional_currency,
2181: l_coa_id
2182: FROM gl_sets_of_books sob
2183: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2184:
2185: ELSIF p_reporting_level = 3000 THEN
2186: SELECT sob.name sob_name,

Line 2194: FROM gl_sets_of_books sob,

2190: INTO l_sob_name,
2191: l_sob_id,
2192: l_functional_currency,
2193: l_coa_id
2194: FROM gl_sets_of_books sob,
2195: ar_system_parameters sysparam
2196: WHERE sob.set_of_books_id = sysparam.set_of_books_id
2197: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2198:

Line 3267: FROM gl_sets_of_books sob

3263: INTO l_sob_name,
3264: l_sob_id,
3265: l_functional_currency,
3266: l_coa_id
3267: FROM gl_sets_of_books sob
3268: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
3269:
3270: ELSIF p_reporting_level = 3000 THEN
3271: SELECT sob.name sob_name,

Line 3279: FROM gl_sets_of_books sob,

3275: INTO l_sob_name,
3276: l_sob_id,
3277: l_functional_currency,
3278: l_coa_id
3279: FROM gl_sets_of_books sob,
3280: ar_system_parameters sysparam
3281: WHERE sob.set_of_books_id = sysparam.set_of_books_id
3282: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
3283:

Line 3865: FROM gl_sets_of_books sob

3861: SELECT sob.name sob_name,
3862: sob.currency_code functional_currency
3863: INTO l_sob_name,
3864: l_functional_currency
3865: FROM gl_sets_of_books sob
3866: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
3867:
3868: ELSIF p_reporting_level = 3000 THEN
3869: SELECT sob.name sob_name,

Line 3873: FROM gl_sets_of_books sob,

3869: SELECT sob.name sob_name,
3870: sob.currency_code functional_currency
3871: INTO l_sob_name,
3872: l_functional_currency
3873: FROM gl_sets_of_books sob,
3874: ar_system_parameters sysparam
3875: WHERE sob.set_of_books_id = sysparam.set_of_books_id
3876: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
3877:

Line 3890: FROM gl_periods p, gl_sets_of_books b

3886: from dual;
3887: /* Get the period start and end dates */
3888: SELECT p.start_date, p.end_date
3889: INTO l_gl_date_from , l_gl_date_to
3890: FROM gl_periods p, gl_sets_of_books b
3891: WHERE p.period_set_name = b.period_set_name
3892: AND p.period_type = b.accounted_period_type
3893: AND b.set_of_books_id = arp_recon_rep.var_tname.g_set_of_books_id
3894: AND p.period_name = arp_recon_rep.var_tname.g_period_name;