DBA Data[Home] [Help]

APPS.OKC_TIME_PVT dependencies on OKC_TIME_IA_STARTEND_VAL_V

Line 936: FROM okc_time_ia_startend_val_v

932: WHERE id = p_id
933: and tve_type = 'TGD';
934: CURSOR okc_limited_csr (p_id IN NUMBER) IS
935: SELECT id, start_date, end_date
936: FROM okc_time_ia_startend_val_v
937: WHERE id = p_id;
938: l_okc_limited okc_limited_csr%ROWTYPE;
939: l_okc_tve okc_tve_csr%ROWTYPE;
940: BEGIN

Line 1485: FROM okc_time_ia_startend_val_v

1481: l_api_name CONSTANT VARCHAR2(30) := 'update_ia_startend';
1482: item_not_found_error EXCEPTION;
1483: CURSOR okc_tve_csr (p_id IN NUMBER) IS
1484: SELECT start_date
1485: FROM okc_time_ia_startend_val_v
1486: WHERE id = p_id ;
1487: l_okc_tve okc_tve_csr%ROWTYPE;
1488: BEGIN
1489: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 2683: FROM okc_time_ia_startend_val_v

2679: WHERE id = p_id
2680: AND tve_type = 'CYL';
2681: CURSOR okc_limited_csr (p_id IN NUMBER) IS
2682: SELECT id, start_date, end_date
2683: FROM okc_time_ia_startend_val_v
2684: WHERE id = p_id;
2685: l_okc_limited okc_limited_csr%ROWTYPE;
2686: l_okc_tve okc_tve_csr%ROWTYPE;
2687: BEGIN