APPS.OKL_TTD_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1007: FROM hr_all_organization_units

1003: l_dummy_var VARCHAR2(1) := '?' ;
1004:
1005: CURSOR okl_ttdv_ioi_fk_csr (p_id IN NUMBER) IS
1006: SELECT 'x'
1007: FROM hr_all_organization_units
1008: WHERE hr_all_organization_units.organization_id = p_id;
1009: BEGIN
1010:
1011: IF (p_ttdv_rec.internal_organization_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.internal_organization_id IS NOT NULL)

Line 1008: WHERE hr_all_organization_units.organization_id = p_id;

1004:
1005: CURSOR okl_ttdv_ioi_fk_csr (p_id IN NUMBER) IS
1006: SELECT 'x'
1007: FROM hr_all_organization_units
1008: WHERE hr_all_organization_units.organization_id = p_id;
1009: BEGIN
1010:
1011: IF (p_ttdv_rec.internal_organization_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.internal_organization_id IS NOT NULL)
1012: THEN

Line 1028: 'HR_ALL_ORGANIZATION_UNITS');

1024: 'internal_organization_id',
1025: g_child_table_token ,
1026: 'OKL_TAX_TRX_DETAILS',
1027: g_parent_table_token ,
1028: 'HR_ALL_ORGANIZATION_UNITS');
1029: l_return_status := OKC_API.G_RET_STS_ERROR;
1030:
1031: END IF;
1032: ELSIF (p_ttdv_rec.internal_organization_id = OKL_API.G_MISS_NUM OR p_ttdv_rec.internal_organization_id IS NULL)

Line 1996: FROM hr_all_organization_units

1992: l_okl_ttdv_tei okl_ttdv_tei_fk_csr%ROWTYPE;
1993:
1994: CURSOR okl_ttdv_ioi_fk_csr (p_id IN NUMBER) IS
1995: SELECT 'x'
1996: FROM hr_all_organization_units
1997: WHERE hr_all_organization_units.organization_id = p_id;
1998: l_okl_ttdv_ioi okl_ttdv_ioi_fk_csr%ROWTYPE;
1999:
2000: CURSOR okl_ttdv_app_id_fk_csr (p_id IN NUMBER) IS

Line 1997: WHERE hr_all_organization_units.organization_id = p_id;

1993:
1994: CURSOR okl_ttdv_ioi_fk_csr (p_id IN NUMBER) IS
1995: SELECT 'x'
1996: FROM hr_all_organization_units
1997: WHERE hr_all_organization_units.organization_id = p_id;
1998: l_okl_ttdv_ioi okl_ttdv_ioi_fk_csr%ROWTYPE;
1999:
2000: CURSOR okl_ttdv_app_id_fk_csr (p_id IN NUMBER) IS
2001: SELECT 'x'