APPS.CST_ACCRUAL_LOAD dependencies on CST_RECONCILIATION_BUILD

Line 156: FROM CST_RECONCILIATION_BUILD

152: x_min_build_date OUT NOCOPY DATE)
153: IS
154: CURSOR min_build_date(p_operating_unit IN NUMBER) IS
155: SELECT MIN(DECODE(from_date,g_def_start_date, g_dummy_date,from_date))
156: FROM CST_RECONCILIATION_BUILD
157: WHERE operating_unit_id = p_operating_unit;
158: BEGIN
159: debug('build_run +');
160: debug(' p_operating_unit :'||p_operating_unit);

Line 713: FROM CST_RECONCILIATION_BUILD

709:
710: /*
711: Select count(*)
712: INTO l_build_count
713: FROM CST_RECONCILIATION_BUILD
714: WHERE operating_unit_id = p_operating_unit
715: AND rownum = 1;
716:
717:

Line 2278: FROM cst_reconciliation_build crb

2274: l_request_id,
2275: l_program_application_id,
2276: l_program_id,
2277: l_program_update_date
2278: FROM cst_reconciliation_build crb
2279: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
2280:
2281: debug(' l_build_id:'||l_build_id);
2282:

Line 2590: FROM cst_reconciliation_build crb

2586: l_request_id,
2587: l_program_application_id,
2588: l_program_id,
2589: l_program_update_date
2590: FROM cst_reconciliation_build crb
2591: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
2592:
2593: debug(' l_build_id :'|| l_build_id);
2594:

Line 2960: | CST_RECONCILIATION_BUILD table for every run of the load |

2956: | |
2957: | Procedure Name : Insert_build_parameters |
2958: | |
2959: | Purpose : This Procedure inserts a row into the |
2960: | CST_RECONCILIATION_BUILD table for every run of the load |
2961: | |
2962: | Called from : Start_accrual_load Procedure |
2963: | |
2964: | Parameters : |

Line 3010: INSERT into CST_RECONCILIATION_BUILD(

3006: debug(' l_stmt_num :'||l_stmt_num);
3007: x_return_status := fnd_api.g_ret_sts_success;
3008:
3009:
3010: INSERT into CST_RECONCILIATION_BUILD(
3011: build_id,
3012: operating_unit_id,
3013: -- HYU: at the from run this is the main xla upgrade date for the OU
3014: from_date,

Line 3026: cst_reconciliation_build_s.nextval,

3022: program_id,
3023: program_application_id,
3024: program_update_date)
3025: values(
3026: cst_reconciliation_build_s.nextval,
3027: p_operating_unit,
3028: p_from_date,
3029: p_to_date,
3030: sysdate,

Line 3249: FROM cst_reconciliation_build crb

3245: l_request_id,
3246: l_program_application_id,
3247: l_program_id,
3248: l_program_update_date
3249: FROM cst_reconciliation_build crb
3250: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
3251: debug(' l_build_id :'||l_build_id);
3252:
3253: OPEN c_po_dists;