DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on OKE_K_DELIVERABLES_VL

Line 1538: FROM oke_k_deliverables_vl

1534: id NUMBER := NULL;
1535:
1536: CURSOR c (val VARCHAR2) IS
1537: SELECT deliverable_id
1538: FROM oke_k_deliverables_vl
1539: WHERE deliverable_num = val;
1540:
1541: BEGIN
1542:

Line 3312: FROM oke_k_deliverables_vl

3308: contract_id := get_contract_id (contract_number);
3309: line_id := get_contract_line_id (line_number);
3310:
3311: sql_string := 'SELECT deliverable_num, description
3312: FROM oke_k_deliverables_vl
3313: WHERE k_header_id = :1 AND
3314: k_line_id = :2 AND
3315: deliverable_num like :3
3316: ORDER BY deliverable_num';