DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 422: FROM hr_organization_information

418: /*Cursor added by ssawant for bug 5989740 */
419: CURSOR cur_fetch_ou(cp_organization_id NUMBER)
420: IS
421: SELECT org_information3
422: FROM hr_organization_information
423: WHERE upper(ORG_INFORMATION_CONTEXT) = 'ACCOUNTING INFORMATION'
424: AND organization_id = cp_organization_id;
425:
426: ln_org_id NUMBER; /* added by ssawant for bug 5989740 */

Line 2503: FROM hr_organization_information

2499:
2500: CURSOR cur_fetch_ou(cp_organization_id NUMBER)
2501: IS
2502: SELECT org_information3
2503: FROM hr_organization_information
2504: WHERE upper(ORG_INFORMATION_CONTEXT) = 'ACCOUNTING INFORMATION'
2505: AND organization_id = cp_organization_id;
2506:
2507: CURSOR cur_get_exc_gain_acc_ar (p_org_id NUMBER)