APPS.OKS_BILL_REC_PUB dependencies on CS_INCIDENTS_ALL_B

Line 2892: FROM CS_INCIDENTS_ALL_B sr

2888: -- against the subline
2889:
2890: Cursor cur_subline_sr(p_id IN NUMBER,p_cp_id IN NUMBER) IS
2891: SELECT 'x'
2892: FROM CS_INCIDENTS_ALL_B sr
2893: where sr.contract_service_id = p_id
2894: AND sr.customer_product_id = p_cp_id
2895: and sr.status_flag = 'O';
2896:

Line 4189: FROM CS_INCIDENTS_ALL_B sr

4185: -- against the line
4186:
4187: Cursor cur_line_sr(p_id IN NUMBER) IS
4188: SELECT 'x'
4189: FROM CS_INCIDENTS_ALL_B sr
4190: WHERE sr.contract_service_id = p_id
4191: AND sr.status_flag = 'O';
4192:
4193: Cursor cur_lineno(p_id IN NUMBER) IS

Line 4205: FROM CS_INCIDENTS_ALL_B sr

4201:
4202: -- Bug 4354983 TAKINTOY
4203: Cursor cur_hdr_sr IS
4204: SELECT 'x'
4205: FROM CS_INCIDENTS_ALL_B sr
4206: WHERE sr.contract_id = p_id
4207: AND sr.status_flag = 'O';
4208:
4209: Cursor cur_contract_num IS

Line 8581: FROM CS_INCIDENTS_ALL_B sr,

8577:
8578: /***************************************************
8579: Cursor cur_subline_sr(p_id IN NUMBER) IS
8580: SELECT 'x'
8581: FROM CS_INCIDENTS_ALL_B sr,
8582: okc_k_items cim
8583: where cim.cle_id = p_id
8584: and sr.customer_product_id = cim.object1_id1
8585: and sr.status_flag = 'O';

Line 8591: CS_INCIDENTS_ALL_B sr

8587:
8588: Cursor cur_subline_sr(p_id IN NUMBER) IS
8589: SELECT 'x'
8590: FROM okc_k_items cim,
8591: CS_INCIDENTS_ALL_B sr
8592: where cim.cle_id = p_cp_line_id
8593: and sr.contract_service_id = p_top_line_id
8594: and sr.customer_product_id = to_number(cim.object1_id1)
8595: and sr.status_flag = 'O' ;