APPS.PO_VAL_DISTRIBUTIONS dependencies on DUAL

Line 1834: FROM dual

1830: Decode(Sign(change_in_funded_value), -1, 0, change_in_funded_value))
1831: FROM po_distributions_merge_v
1832: WHERE po_distribution_id = p_dist_id_tbl(i)
1833: AND draft_id = Nvl(p_draft_id_tbl(i), -1))
1834: FROM dual
1835: WHERE p_req_dist_id_tbl(i) IS NOT NULL
1836: AND p_dist_type_tbl(i) = c_STANDARD
1837: AND PO_DOC_STYLE_HELPER.get_clm_flag(p_style_id => p_style_id_tbl(i)) = 'Y'
1838: AND EXISTS(

Line 2116: FROM dual

2112: l_results_count := l_results_count + l_lines_count;
2113: ELSE
2114: BEGIN
2115: SELECT 'Y' INTO is_defence_funding_valid
2116: FROM dual
2117: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
2118: WHERE LOOKUP_TYPE = 'PO_FUND_INDICATOR'
2119: AND lookup_code = p_clm_defence_funding_tbl(i)
2120: );