APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on DUAL

Line 558: FROM DUAL ;

554: rlog ('Sales Person Code - '||l_salesperson_code,1);
555: SELECT NVL(BIS_COMMON_PARAMETERS.get_batch_size(BIS_COMMON_PARAMETERS.HIGH)
556: , 1000)
557: INTO l_batch_size
558: FROM DUAL ;
559:
560: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
561:
562: SELECT MAX(renewal_id),MAX(ren_con_id)

Line 1111: FROM DUAL ;

1107:
1108: SELECT NVL(BIS_COMMON_PARAMETERS.get_batch_size(BIS_COMMON_PARAMETERS.HIGH)
1109: , 1000)
1110: INTO l_batch_size
1111: FROM DUAL ;
1112:
1113: g_batch_size := l_batch_size;
1114: IF (FND_INSTALLATION.GET_APP_INFO(
1115: application_short_name => 'OKI'

Line 1350: , NVL((SELECT to_number(substr(salesrep_attribs,1,instr(salesrep_attribs,'#')-1)) from dual),-1) salesrep_id

1346: , func_currency
1347: , trx_func_rate
1348: , batch_id
1349: , grace_end_date
1350: , NVL((SELECT to_number(substr(salesrep_attribs,1,instr(salesrep_attribs,'#')-1)) from dual),-1) salesrep_id
1351: , NVL((SELECT to_number(substr(salesrep_attribs,instr(salesrep_attribs,'#')+1)) from dual),-1) resource_group_id
1352: , gsd_flag
1353: , authoring_org_id
1354: , application_id

Line 1351: , NVL((SELECT to_number(substr(salesrep_attribs,instr(salesrep_attribs,'#')+1)) from dual),-1) resource_group_id

1347: , trx_func_rate
1348: , batch_id
1349: , grace_end_date
1350: , NVL((SELECT to_number(substr(salesrep_attribs,1,instr(salesrep_attribs,'#')-1)) from dual),-1) salesrep_id
1351: , NVL((SELECT to_number(substr(salesrep_attribs,instr(salesrep_attribs,'#')+1)) from dual),-1) resource_group_id
1352: , gsd_flag
1353: , authoring_org_id
1354: , application_id
1355: , contract_number

Line 1425: END)+1 FROM DUAL) AS GRACE_END_DATE

1421: WHEN tcu.tce_code IN ('MINUTE')
1422: THEN h.end_date
1423: + (((24 * 60) - 1) / (24 * 60))
1424: + ((sh.grace_duration * tcu.quantity) / (24 * 60))
1425: END)+1 FROM DUAL) AS GRACE_END_DATE
1426: ,( SELECT nvl(max(srep.object1_id1) keep (dense_rank first
1427: ORDER BY CASE WHEN (l_sysdate
1428: BETWEEN NVL(srep.start_date,l_sysdate)
1429: AND NVL(srep.end_date,l_sysdate))

Line 2634: , (select to_number(substr(ilv1.service_item_attribs,1,instr(service_item_attribs,'#')-1)) from dual) service_item_id

2630: , ilv1.hdr_date_cancelled
2631: , ilv1.hdr_date_terminated
2632: , ilv1.hdr_creation_date
2633: , ilv1.hdr_last_update_date
2634: , (select to_number(substr(ilv1.service_item_attribs,1,instr(service_item_attribs,'#')-1)) from dual) service_item_id
2635: , (select to_number(substr(ilv1.service_item_attribs,instr(service_item_attribs,'#')+1)) from dual) service_item_org_id
2636: , ilv1.sl_line_number
2637: , ilv1.sl_sts_code
2638: , ilv1.sl_trn_code

Line 2635: , (select to_number(substr(ilv1.service_item_attribs,instr(service_item_attribs,'#')+1)) from dual) service_item_org_id

2631: , ilv1.hdr_date_terminated
2632: , ilv1.hdr_creation_date
2633: , ilv1.hdr_last_update_date
2634: , (select to_number(substr(ilv1.service_item_attribs,1,instr(service_item_attribs,'#')-1)) from dual) service_item_id
2635: , (select to_number(substr(ilv1.service_item_attribs,instr(service_item_attribs,'#')+1)) from dual) service_item_org_id
2636: , ilv1.sl_line_number
2637: , ilv1.sl_sts_code
2638: , ilv1.sl_trn_code
2639: , ilv1.sl_renewal_type