DBA Data[Home] [Help]

APPS.PQH_GL_POSTING dependencies on HR_ORGANIZATION_INFORMATION

Line 404: FROM HR_ORGANIZATION_INFORMATION bg

400: */
401:
402: CURSOR csr_bus_grp (p_business_group_id IN NUMBER) IS
403: SELECT bg.ORG_INFORMATION10
404: FROM HR_ORGANIZATION_INFORMATION bg
405: WHERE bg.organization_id = p_business_group_id
406: AND bg.ORG_INFORMATION_CONTEXT = 'Business Group Information';
407:
408: CURSOR csr_chart_of_acc_id(p_set_of_books_id IN NUMBER) IS

Line 3540: FROM HR_ORGANIZATION_INFORMATION bg,

3536: l_budget_curr varchar2(150) := '';
3537:
3538: CURSOR csr_curr_code IS
3539: SELECT bg.ORG_INFORMATION10
3540: FROM HR_ORGANIZATION_INFORMATION bg,
3541: pqh_budgets bgt,
3542: pqh_budget_versions bvr
3543: WHERE bgt.budget_id = bvr.budget_id
3544: AND bvr.budget_version_id = g_budget_version_id