DBA Data[Home] [Help]

APPS.OKL_TTD_PVT dependencies on ZX_EXEMPTIONS

Line 956: FROM zx_exemptions

952: l_dummy_var VARCHAR2(1) := '?' ;
953:
954: CURSOR okl_ttdv_tei_fk_csr (p_id IN NUMBER) IS
955: SELECT 'x'
956: FROM zx_exemptions
957: WHERE zx_exemptions.tax_exemption_id = p_id;
958: BEGIN
959:
960: IF (p_ttdv_rec.tax_exemption_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_exemption_id IS NOT NULL)

Line 957: WHERE zx_exemptions.tax_exemption_id = p_id;

953:
954: CURSOR okl_ttdv_tei_fk_csr (p_id IN NUMBER) IS
955: SELECT 'x'
956: FROM zx_exemptions
957: WHERE zx_exemptions.tax_exemption_id = p_id;
958: BEGIN
959:
960: IF (p_ttdv_rec.tax_exemption_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_exemption_id IS NOT NULL)
961: THEN

Line 977: 'ZX_EXEMPTIONS');

973: 'tax_exemption_id',
974: g_child_table_token ,
975: 'OKL_TAX_TRX_DETAILS',
976: g_parent_table_token ,
977: 'ZX_EXEMPTIONS');
978: l_return_status := OKC_API.G_RET_STS_ERROR;
979:
980: END IF;
981:

Line 1990: FROM zx_exemptions

1986: l_okl_ttdv_trc okl_ttdv_trc_fk_csr%ROWTYPE;
1987:
1988: CURSOR okl_ttdv_tei_fk_csr (p_id IN NUMBER) IS
1989: SELECT 'x'
1990: FROM zx_exemptions
1991: WHERE zx_exemptions.tax_exemption_id = p_id;
1992: l_okl_ttdv_tei okl_ttdv_tei_fk_csr%ROWTYPE;
1993:
1994: CURSOR okl_ttdv_ioi_fk_csr (p_id IN NUMBER) IS

Line 1991: WHERE zx_exemptions.tax_exemption_id = p_id;

1987:
1988: CURSOR okl_ttdv_tei_fk_csr (p_id IN NUMBER) IS
1989: SELECT 'x'
1990: FROM zx_exemptions
1991: WHERE zx_exemptions.tax_exemption_id = p_id;
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'