DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on DUAL

Line 265: FROM dual

261: SELECT
262: p_key_name
263: ,p_product_name
264: ,p_key_value
265: FROM dual
266: WHERE NOT EXISTS (SELECT NULL
267: FROM hr_s_application_ownerships
268: WHERE product_name = p_product_name
269: AND key_name = p_key_name

Line 325: FROM dual WHERE EXISTS (SELECT NULL FROM pay_element_classifications

321:
322: BEGIN
323: SELECT 1
324: INTO l_reference
325: FROM dual WHERE EXISTS (SELECT NULL FROM pay_element_classifications
326: WHERE nvl(legislation_code,'X') = 'ZZ'
327: AND business_group_id IS NULL);
328:
329: EXCEPTION

Line 1415: FROM dual

1411: SELECT
1412: 'ZZ'
1413: ,p_rule_type
1414: ,p_rule_mode
1415: FROM dual
1416: WHERE NOT EXISTS (SELECT NULL
1417: FROM hr_s_legislation_rules
1418: WHERE legislation_code = 'ZZ'
1419: AND rule_type = p_rule_type);