APPS.PO_VAL_LINES dependencies on DUAL

Line 3827: SELECT 1 INTO l_excep FROM dual

3823: END IF;
3824:
3825: IF (l_excep = 0) THEN
3826: BEGIN
3827: SELECT 1 INTO l_excep FROM dual
3828: WHERE p_line_num_disp_tbl(i) LIKE p_clm_exhibit_name_tbl(i)||'%';
3829:
3830: EXCEPTION
3831: WHEN No_Data_Found THEN

Line 3897: FROM DUAL

3893: ,p_line_id_tbl(i)
3894: ,PO_MESSAGE_S.PO_MOD_CANCEL_INVALID
3895: ,c_CONTROL_ACTION
3896: ,TO_CHAR(p_control_action_tbl(i))
3897: FROM DUAL
3898: WHERE nvl(p_control_action_tbl(i), '*') = 'CANCEL'
3899: AND not exists
3900: (SELECT 'Y'
3901: FROM PO_LINE_LOCATIONS_ALL

Line 3997: USING DUAL

3993:
3994: -- Merge in the new data.
3995: FORALL i IN 1 .. p_line_id_tbl.COUNT
3996: MERGE INTO PO_SESSION_GT SES
3997: USING DUAL
3998: ON
3999: ( SES.key = l_data_key
4000: AND SES.index_num2 = p_line_id_tbl(i)
4001: AND SES.index_num1 = p_header_id_tbl(i)

Line 4236: FROM dual

4232:
4233: ELSE
4234: BEGIN
4235: SELECT 'Y' INTO is_contract_type_valid
4236: FROM dual
4237: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
4238: WHERE lookup_type = Decode(p_order_type_lookup_code_tbl(i),
4239: 'FIXED PRICE','PO_FEDERAL_CONTRACT_TYPES_AMT',
4240: 'AMOUNT','PO_FEDERAL_CONTRACT_TYPES_AMT',

Line 4315: FROM dual

4311: IF p_cost_constraint_tbl(i) IS NOT NULL
4312: THEN
4313: BEGIN
4314: SELECT 'Y' INTO is_cost_constraint_valid
4315: FROM dual
4316: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
4317: WHERE lookup_type = 'PO_FEDERAL_COST_CONSTRAINTS'
4318: AND lookup_code = p_cost_constraint_tbl(i)
4319: );

Line 4400: FROM dual

4396: END IF;
4397: ELSE
4398: BEGIN
4399: SELECT 'Y' INTO is_contract_valid
4400: FROM dual
4401: WHERE EXISTS ( SELECT 1 FROM okc_k_headers_b
4402: WHERE id = p_oke_contract_header_id_tbl(i)
4403: );
4404: EXCEPTION WHEN No_Data_Found

Line 4417: FROM dual

4413: END;
4414:
4415: BEGIN
4416: SELECT 'Y' INTO is_contract_valid
4417: FROM dual
4418: WHERE EXISTS ( SELECT major_version FROM oke_k_vers_numbers_v
4419: WHERE chr_id = p_oke_contract_header_id_tbl(i)
4420: AND major_version = p_oke_contract_version_id_tbl(i)
4421: UNION

Line 4758: FROM dual

4754: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
4755: THEN
4756: BEGIN
4757: SELECT 'Y' INTO is_valid_idc_type
4758: FROM dual
4759: WHERE EXISTS ( SELECT 1 FROM PO_LOOKUP_CODES
4760: WHERE LOOKUP_TYPE = 'PO_FEDERAL_IDC_TYPES'
4761: AND lookup_code = p_clm_idc_type_tbl(i)
4762: );