APPS.CS_GET_COVERAGE_VALUES_PUB dependencies on CS_COVERAGES

Line 45: l_coverage_id CS_COVERAGES.COVERAGE_ID%TYPE;

41: x_ltem_price OUT NUMBER,
42: x_return_status OUT VARCHAR2,
43: x_msg_count OUT NUMBER,
44: x_msg_data OUT VARCHAR2 ) IS
45: l_coverage_id CS_COVERAGES.COVERAGE_ID%TYPE;
46:
47: CURSOR Bill_Rate_UOM_csr IS
48: SELECT CBR.Flat_Rate,
49: CBR.Percent_Rate

Line 220: l_coverage_id CS_COVERAGES.COVERAGE_ID%TYPE;

216: x_preferred_engineer2 OUT VARCHAR2,
217: x_return_status OUT VARCHAR2,
218: x_msg_count OUT NUMBER,
219: x_msg_data OUT VARCHAR2 ) IS
220: l_coverage_id CS_COVERAGES.COVERAGE_ID%TYPE;
221:
222: CURSOR Preferred_Engineer_csr IS
223: SELECT TXN.Preferred_Engineer1,
224: TXN.Preferred_Engineer2

Line 343: FROM CS_COVERAGES COV1,

339: x_msg_count OUT NUMBER,
340: x_msg_data OUT VARCHAR2 ) IS
341: CURSOR Exception_Coverage_csr IS
342: SELECT COV2.Coverage_id
343: FROM CS_COVERAGES COV1,
344: CS_COVERAGES COV2
345: WHERE COV1.Coverage_id = p_coverage_id
346: AND COV2.Coverage_id = COV1.Exception_Coverage_id;
347:

Line 344: CS_COVERAGES COV2

340: x_msg_data OUT VARCHAR2 ) IS
341: CURSOR Exception_Coverage_csr IS
342: SELECT COV2.Coverage_id
343: FROM CS_COVERAGES COV1,
344: CS_COVERAGES COV2
345: WHERE COV1.Coverage_id = p_coverage_id
346: AND COV2.Coverage_id = COV1.Exception_Coverage_id;
347:
348: l_api_name CONSTANT VARCHAR2(30) := 'Get_Exception_Coverage';