DBA Data[Home] [Help]

APPS.JAI_PO_CST_TRIGGER_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 23: cpv_information_context HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_CONTEXT%TYPE

19: lv_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
20:
21: CURSOR cur_get_setOfBooksId
22: (cpn_operating_unit_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE,
23: cpv_information_context HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_CONTEXT%TYPE
24: )
25: IS
26: SELECT to_number(o3.org_information3) set_of_books_id
27: FROM hr_organization_information o3

Line 27: FROM hr_organization_information o3

23: cpv_information_context HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_CONTEXT%TYPE
24: )
25: IS
26: SELECT to_number(o3.org_information3) set_of_books_id
27: FROM hr_organization_information o3
28: WHERE organization_id = cpn_operating_unit_id
29: AND o3.org_information_context = cpv_information_context;
30:
31: CURSOR cur_get_accrual_amount