DBA Data[Home] [Help]

APPS.OKC_TIME_RES_PVT dependencies on OKC_TIME_IA_STARTEND_VAL_V

Line 973: from okc_time_ia_startend_val_v ise

969: CURSOR limited_by_csr(p_tve_id IN NUMBER) is
970: select nvl(ise.start_date,to_date('01010001','ddmmyyyy')) start_date,
971: nvl(ise.end_date,to_date('31124000','ddmmyyyy')) end_date,
972: tze_id
973: from okc_time_ia_startend_val_v ise
974: where ise.id = p_tve_id;
975:
976: l_list_of_rules VARCHAR2(4000);
977: l_list_of_rules1 VARCHAR2(4000);

Line 1315: from okc_time_ia_startend_val_v ise

1311: CURSOR limited_by_csr(p_tve_id IN NUMBER) is
1312: select nvl(ise.start_date,to_date('01010001','ddmmyyyy')) start_date,
1313: nvl(ise.end_date,to_date('31124000','ddmmyyyy')) end_date,
1314: tze_id
1315: from okc_time_ia_startend_val_v ise
1316: where ise.id = p_tve_id;
1317:
1318:
1319: CURSOR resolved_until_csr(p_cle_id IN NUMBER) is