APPS.OKL_TTD_PVT dependencies on ZX_RATES_B

Line 854: FROM zx_rates_b

850: l_dummy_var VARCHAR2(1) := '?' ;
851:
852: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
853: SELECT 'x'
854: FROM zx_rates_b
855: WHERE zx_rates_b.tax_rate_id = p_id;
856: BEGIN
857:
858: IF (p_ttdv_rec.tax_rate_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_rate_id IS NOT NULL)

Line 855: WHERE zx_rates_b.tax_rate_id = p_id;

851:
852: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
853: SELECT 'x'
854: FROM zx_rates_b
855: WHERE zx_rates_b.tax_rate_id = p_id;
856: BEGIN
857:
858: IF (p_ttdv_rec.tax_rate_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_rate_id IS NOT NULL)
859: THEN

Line 875: 'ZX_RATES_B');

871: 'tax_rate_id',
872: g_child_table_token ,
873: 'OKL_TAX_TRX_DETAILS',
874: g_parent_table_token ,
875: 'ZX_RATES_B');
876: l_return_status := OKC_API.G_RET_STS_ERROR;
877:
878: END IF;
879:

Line 905: FROM zx_rates_b

901: l_dummy_var VARCHAR2(1) := '?' ;
902:
903: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
904: SELECT 'x'
905: FROM zx_rates_b
906: WHERE zx_rates_b.tax_rate_code = p_code;
907: BEGIN
908:
909: IF (p_ttdv_rec.tax_rate_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_rate_code IS NOT NULL)

Line 906: WHERE zx_rates_b.tax_rate_code = p_code;

902:
903: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
904: SELECT 'x'
905: FROM zx_rates_b
906: WHERE zx_rates_b.tax_rate_code = p_code;
907: BEGIN
908:
909: IF (p_ttdv_rec.tax_rate_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_rate_code IS NOT NULL)
910: THEN

Line 926: 'ZX_RATES_B');

922: 'tax_rate_code',
923: g_child_table_token ,
924: 'OKL_TAX_TRX_DETAILS',
925: g_parent_table_token ,
926: 'ZX_RATES_B');
927: l_return_status := OKC_API.G_RET_STS_ERROR;
928:
929: END IF;
930:

Line 1978: FROM zx_rates_b

1974: l_okl_ttdv_txs_id okl_ttdv_txs_id_csr%ROWTYPE;
1975:
1976: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
1977: SELECT 'x'
1978: FROM zx_rates_b
1979: WHERE zx_rates_b.tax_rate_id = p_id;
1980: l_okl_ttdv_tri okl_ttdv_tri_fk_csr%ROWTYPE;
1981:
1982: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS

Line 1979: WHERE zx_rates_b.tax_rate_id = p_id;

1975:
1976: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
1977: SELECT 'x'
1978: FROM zx_rates_b
1979: WHERE zx_rates_b.tax_rate_id = p_id;
1980: l_okl_ttdv_tri okl_ttdv_tri_fk_csr%ROWTYPE;
1981:
1982: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
1983: SELECT 'x'

Line 1984: FROM zx_rates_b

1980: l_okl_ttdv_tri okl_ttdv_tri_fk_csr%ROWTYPE;
1981:
1982: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
1983: SELECT 'x'
1984: FROM zx_rates_b
1985: WHERE zx_rates_b.tax_rate_code = p_code;
1986: l_okl_ttdv_trc okl_ttdv_trc_fk_csr%ROWTYPE;
1987:
1988: CURSOR okl_ttdv_tei_fk_csr (p_id IN NUMBER) IS

Line 1985: WHERE zx_rates_b.tax_rate_code = p_code;

1981:
1982: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
1983: SELECT 'x'
1984: FROM zx_rates_b
1985: WHERE zx_rates_b.tax_rate_code = p_code;
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'