[Home] [Help]
1472:
1473: -- added for ER 13245462
1474: CURSOR spa_partial_appr_flag (c_org_id NUMBER) IS
1475: select SSD_IMD_CLAIM_FLAG
1476: from OZF_SYS_PARAMETERS_ALL
1477: where org_id = c_org_id;
1478:
1479: BEGIN
1480:
1769:
1770: SELECT gs.currency_code
1771: INTO l_func_currency
1772: FROM gl_sets_of_books gs,
1773: ozf_sys_parameters_all org,
1774: ozf_sd_batch_headers_all bh
1775: WHERE org.set_of_books_id = gs.set_of_books_id
1776: AND org.org_id = bh.org_id
1777: AND bh.batch_id = p_batch_id;
1912: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1913: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');
1914: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');
1915: FND_DSQL.add_text('HZ_CUST_ACCOUNTS HZCA, ');
1916: FND_DSQL.add_text('OZF_SYS_PARAMETERS_ALL ospa ');
1917:
1918: --BEGIN WHERE CLAUSE
1919: FND_DSQL.add_text('WHERE FU.PLAN_ID = RH.OFFER_ID AND ');
1920: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
2638:
2639: SELECT gs.currency_code
2640: INTO l_func_currency
2641: FROM gl_sets_of_books gs,
2642: ozf_sys_parameters_all org,
2643: ozf_sd_batch_headers_all bh
2644: WHERE org.set_of_books_id = gs.set_of_books_id
2645: AND org.org_id = bh.org_id
2646: AND bh.batch_id = p_batch_id;
2768: FND_DSQL.add_text('OZF_RESALE_LINES_ALL ORL, ');
2769: FND_DSQL.add_text('OZF_RESALE_BATCH_LINE_MAPS_ALL ORBMP, ');
2770: FND_DSQL.add_text('OZF_RESALE_BATCHES_ALL ORB, ');
2771: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
2772: FND_DSQL.add_text('OZF_SYS_PARAMETERS_ALL ospa ');
2773:
2774: --BEGIN WHERE CLAUSE
2775: FND_DSQL.add_text('WHERE FU.PLAN_ID = RH.OFFER_ID AND ');
2776: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
3783:
3784: SELECT gs.currency_code
3785: INTO l_func_currency
3786: FROM gl_sets_of_books gs,
3787: ozf_sys_parameters_all org,
3788: ozf_sd_batch_headers_all bh
3789: WHERE org.set_of_books_id = gs.set_of_books_id
3790: AND org.org_id = bh.org_id
3791: AND bh.batch_id = batch_rec.BATCH_ID;