DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 347: FROM hr_organization_information ood,

343: l_stmt_num := 70;
344:
345: SELECT gsob.period_set_name
346: INTO l_period_set_name
347: FROM hr_organization_information ood,
348: gl_sets_of_books gsob
349: WHERE ood.organization_id = l_organization_id
350: AND to_number(ood.org_information1) = gsob.set_of_books_id
351: AND ood.org_information_context||'' = 'Accounting Information';

Line 462: select currency_code curr_code into l_currency from hr_organization_information, gl_sets_of_books where set_of_books_id = ORG_INFORMATION1 and organization_id = l_organization_id and ORG_INFORMATION_CONTEXT = 'Accounting Information';

458: l_organization_id := p_organization_id;
459:
460: l_stmt_num := 70;
461:
462: select currency_code curr_code into l_currency from hr_organization_information, gl_sets_of_books where set_of_books_id = ORG_INFORMATION1 and organization_id = l_organization_id and ORG_INFORMATION_CONTEXT = 'Accounting Information';
463:
464: x_currency := l_currency;
465:
466: l_stmt_num := 998;