DBA Data[Home] [Help]

APPS.OKL_TTD_PVT dependencies on FND_APPLICATION

Line 1062: FROM fnd_application

1058: l_dummy_var VARCHAR2(1) := '?' ;
1059:
1060: CURSOR okl_ttdv_app_id_fk_csr (p_id IN NUMBER) IS
1061: SELECT 'x'
1062: FROM fnd_application
1063: WHERE fnd_application.application_id = p_id;
1064: BEGIN
1065:
1066: IF (p_ttdv_rec.application_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.application_id IS NOT NULL)

Line 1063: WHERE fnd_application.application_id = p_id;

1059:
1060: CURSOR okl_ttdv_app_id_fk_csr (p_id IN NUMBER) IS
1061: SELECT 'x'
1062: FROM fnd_application
1063: WHERE fnd_application.application_id = p_id;
1064: BEGIN
1065:
1066: IF (p_ttdv_rec.application_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.application_id IS NOT NULL)
1067: THEN

Line 1083: 'FND_APPLICATION');

1079: 'application_id',
1080: g_child_table_token ,
1081: 'OKL_TAX_TRX_DETAILS',
1082: g_parent_table_token ,
1083: 'FND_APPLICATION');
1084: l_return_status := OKC_API.G_RET_STS_ERROR;
1085:
1086: END IF;
1087: ELSIF (p_ttdv_rec.application_id = OKL_API.G_MISS_NUM OR p_ttdv_rec.application_id IS NULL)

Line 2002: FROM fnd_application

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'
2002: FROM fnd_application
2003: WHERE fnd_application.application_id = p_id;
2004: l_okl_ttdv_app_id okl_ttdv_app_id_fk_csr%ROWTYPE;
2005:
2006: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS

Line 2003: WHERE fnd_application.application_id = p_id;

1999:
2000: CURSOR okl_ttdv_app_id_fk_csr (p_id IN NUMBER) IS
2001: SELECT 'x'
2002: FROM fnd_application
2003: WHERE fnd_application.application_id = p_id;
2004: l_okl_ttdv_app_id okl_ttdv_app_id_fk_csr%ROWTYPE;
2005:
2006: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
2007: SELECT 'x'