DBA Data[Home] [Help]

APPS.OKE_IMPORT_CONTRACT_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 39: from hr_all_organization_units hr , mtl_parameters mp

35: p_chr_rec IN chr_rec_type)IS
36:
37: CURSOR l_csr1 IS
38: select 'x'
39: from hr_all_organization_units hr , mtl_parameters mp
40: where mp.organization_id = hr.organization_id
41: and mp.master_organization_id = mp.organization_id
42: and hr.organization_id = p_chr_rec.inv_organization_id;
43:

Line 102: p_token3_value => 'HR_ALL_ORGANIZATION_UNITS,MTL_PARAMETERS');

98: p_token1_value => 'INV_ORGANIZATION_ID',
99: p_token2 => g_child_table_token,
100: p_token2_value => G_VIEW,
101: p_token3 => g_parent_table_token,
102: p_token3_value => 'HR_ALL_ORGANIZATION_UNITS,MTL_PARAMETERS');
103: x_return_status := OKE_API.G_RET_STS_ERROR;
104: END IF;
105: END IF;
106: