APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on DUAL

Line 923: SELECT 1 FROM DUAL WHERE EXISTS

919: WHERE b.site_use_id = p_account_site_id
920: AND b.cust_acct_site_id = a.cust_acct_site_id;
921:
922: CURSOR sales_transation_csr(p_line_id IN NUMBER) IS
923: SELECT 1 FROM DUAL WHERE EXISTS
924: ( SELECT 1
925: FROM ozf_sales_transactions_all trx
926: WHERE trx.line_id = p_line_id
927: AND source_code = 'OM');

Line 1244: --loop to get individual group number from the comma seperated list

1240: write_conc_log ('l_order_line_tbl(j).group_nos: ' || l_order_line_tbl(j).group_nos);
1241:
1242: IF l_order_line_tbl(j).group_nos IS NOT NULL THEN
1243:
1244: --loop to get individual group number from the comma seperated list
1245: l_string := l_order_line_tbl(j).group_nos;
1246: LOOP
1247: l_last_pos := INSTR(l_string,',',1,l_cntr+1);
1248: l_num_chars := l_last_pos - l_first_pos;

Line 2837: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';

2833: -- with all items but insert -1 instead
2834: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);
2835: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
2836: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
2837: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
2838: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
2839: ----DBMS_output.put_line (' IN ALL products ');
2840: ELSE
2841: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (

Line 2838: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');

2834: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);
2835: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
2836: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
2837: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
2838: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
2839: ----DBMS_output.put_line (' IN ALL products ');
2840: ELSE
2841: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (
2842: p_context=> 'ITEM',

Line 3825: SELECT summ.individual_volume

3821: AND p_volume <= volume_to
3822: AND parent_discount_line_id = p_parent_discount_id;
3823:
3824: /* CURSOR c_max_volume(p_order_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_source_code IN VARCHAR2) IS
3825: SELECT summ.individual_volume
3826: FROM ozf_volume_detail det,ozf_volume_summary summ
3827: WHERE det.order_line_id = p_order_line_id
3828: AND det.qp_list_header_id = p_qp_list_header_id
3829: AND det.volume_track_type = summ.individual_type

Line 3829: AND det.volume_track_type = summ.individual_type

3825: SELECT summ.individual_volume
3826: FROM ozf_volume_detail det,ozf_volume_summary summ
3827: WHERE det.order_line_id = p_order_line_id
3828: AND det.qp_list_header_id = p_qp_list_header_id
3829: AND det.volume_track_type = summ.individual_type
3830: AND det.qp_list_header_id = summ.qp_list_header_id
3831: AND det.source_code = p_source_code;
3832: */
3833: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS

Line 4818: SELECT 1 FROM DUAL WHERE EXISTS

4814:
4815: );
4816:
4817: CURSOR c_is_util_correct(p_list_header_id IN NUMBER) IS
4818: SELECT 1 FROM DUAL WHERE EXISTS
4819: ( SELECT 1
4820: FROM
4821: ( SELECT sum(plan_curr_amount) old_Adj_amt
4822: , order_line_id