APPS.HR_BALANCE_FEEDS dependencies on DUAL

Line 526: from sys.dual

522: 0,
523: 0,
524: 0,
525: trunc(sysdate)
526: from sys.dual
527: where not exists
528: (select null
529: from pay_balance_feeds_f bf
530: where bf.input_value_id = p_input_value_id

Line 1584: from dual

1580: p_validation_start_date date,
1581: p_validation_end_date date
1582: ) is
1583: select 1
1584: from dual
1585: where exists
1586: (select /*+ ORDERED USE_NL(rrv rr aa pa)
1587: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null
1588: from pay_run_result_values rrv,

Line 1695: from dual

1691: p_validation_start_date date,
1692: p_validation_end_date date
1693: ) is
1694: select 1
1695: from dual
1696: where
1697: exists (select /*+ FIRST_ROWS ORDERED
1698: USE_NL(rrv rr aa pa)
1699: INDEX(rrv PAY_RUN_RESULT_VALUES_PK)

Line 1734: from dual

1730: (
1731: p_input_value_id number
1732: ) is
1733: select 1
1734: from dual
1735: where
1736: exists (select 1
1737: from pay_run_result_values rrv
1738: where rrv.input_value_id = p_input_value_id);

Line 1746: from dual

1742: p_payroll_action_id number,
1743: p_input_value_id number
1744: ) is
1745: select 1
1746: from dual
1747: where
1748: exists (select /*+ FIRST_ROWS ORDERED
1749: USE_NL(rr aa rrv)
1750: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)