DBA Data[Home] [Help]

APPS.HRI_BPL_CCMGR dependencies on HRI_CL_ORG_CC_V

Line 11: hri_cl_org_cc_v cl_cc

7: CURSOR ccmgr_csr IS
8: SELECT
9: o_mgr.org_information2
10: FROM
11: hri_cl_org_cc_v cl_cc
12: ,hr_organization_information o_mgr
13: WHERE o_mgr.org_information_context = 'Organization Name Alias'
14: AND cl_cc.ID = o_mgr.organization_id
15: AND cl_cc.ID = p_organization_id;