APPS.OKS_BILL_REC_PUB dependencies on CS_INCIDENTS_ALL_B

Line 2906: FROM CS_INCIDENTS_ALL_B sr

2902: -- against the subline
2903:
2904: Cursor cur_subline_sr(p_id IN NUMBER,p_cp_id IN NUMBER) IS
2905: SELECT 'x'
2906: FROM CS_INCIDENTS_ALL_B sr
2907: where sr.contract_service_id = p_id
2908: AND sr.customer_product_id = p_cp_id
2909: and sr.status_flag = 'O';
2910:

Line 4215: FROM CS_INCIDENTS_ALL_B sr

4211: -- against the line
4212:
4213: Cursor cur_line_sr(p_id IN NUMBER) IS
4214: SELECT 'x'
4215: FROM CS_INCIDENTS_ALL_B sr
4216: WHERE sr.contract_service_id = p_id
4217: AND sr.status_flag = 'O';
4218:
4219: Cursor cur_lineno(p_id IN NUMBER) IS

Line 4231: FROM CS_INCIDENTS_ALL_B sr

4227:
4228: -- Bug 4354983 TAKINTOY
4229: Cursor cur_hdr_sr IS
4230: SELECT 'x'
4231: FROM CS_INCIDENTS_ALL_B sr
4232: WHERE sr.contract_id = p_id
4233: AND sr.status_flag = 'O';
4234:
4235: Cursor cur_contract_num IS

Line 8621: FROM CS_INCIDENTS_ALL_B sr,

8617:
8618: /***************************************************
8619: Cursor cur_subline_sr(p_id IN NUMBER) IS
8620: SELECT 'x'
8621: FROM CS_INCIDENTS_ALL_B sr,
8622: okc_k_items cim
8623: where cim.cle_id = p_id
8624: and sr.customer_product_id = cim.object1_id1
8625: and sr.status_flag = 'O';

Line 8631: CS_INCIDENTS_ALL_B sr

8627:
8628: Cursor cur_subline_sr(p_id IN NUMBER) IS
8629: SELECT 'x'
8630: FROM okc_k_items cim,
8631: CS_INCIDENTS_ALL_B sr
8632: where cim.cle_id = p_cp_line_id
8633: and sr.contract_service_id = p_top_line_id
8634: and sr.customer_product_id = to_number(cim.object1_id1)
8635: and sr.status_flag = 'O' ;