APPS.HR_BALANCE_FEEDS dependencies on DUAL

Line 518: from sys.dual

514: 0,
515: 0,
516: 0,
517: trunc(sysdate)
518: from sys.dual
519: where not exists
520: (select null
521: from pay_balance_feeds_f bf
522: where bf.input_value_id = p_input_value_id

Line 1574: from dual

1570: p_validation_start_date date,
1571: p_validation_end_date date
1572: ) is
1573: select 1
1574: from dual
1575: where exists
1576: (select /*+ ORDERED USE_NL(rrv rr aa pa)
1577: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null
1578: from pay_run_result_values rrv,

Line 1685: from dual

1681: p_validation_start_date date,
1682: p_validation_end_date date
1683: ) is
1684: select 1
1685: from dual
1686: where
1687: exists (select /*+ FIRST_ROWS ORDERED
1688: USE_NL(rrv rr aa pa)
1689: INDEX(rrv PAY_RUN_RESULT_VALUES_PK)

Line 1724: from dual

1720: (
1721: p_input_value_id number
1722: ) is
1723: select 1
1724: from dual
1725: where
1726: exists (select 1
1727: from pay_run_result_values rrv
1728: where rrv.input_value_id = p_input_value_id);

Line 1736: from dual

1732: p_payroll_action_id number,
1733: p_input_value_id number
1734: ) is
1735: select 1
1736: from dual
1737: where
1738: exists (select /*+ FIRST_ROWS ORDERED
1739: USE_NL(rr aa rrv)
1740: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)