DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on DUAL

Line 1343: from dual

1339: begin
1340: --
1341: select ''
1342: into l_dummy
1343: from dual
1344: where exists (select ''
1345: from pay_payroll_actions ppa,
1346: pay_assignment_actions paa
1347: where paa.assignment_id = p_assignment_id

Line 1650: from dual

1646: l_ee_id :=
1647: glo_datetrack_ee_tab(curr_ptr).element_entry_id;
1648: select ''
1649: into l_dummy
1650: from dual
1651: where exists (select ''
1652: from pay_element_entry_values_f
1653: where element_entry_id = l_ee_id
1654: and element_entry_value_id =

Line 1793: l_statement := 'SELECT 1 FROM dual WHERE EXISTS (select 1 from '

1789: l_result:=0;
1790: IF (p_updated_column_name=p_end_date_name)
1791: THEN
1792:
1793: l_statement := 'SELECT 1 FROM dual WHERE EXISTS (select 1 from '
1794: || p_table_name || ' where ' ||
1795: p_surrogate_key_name ||' = :p_surrogate_key '||
1796: ' and ' || p_end_date_name ||' > :col1)';
1797: if (g_traces) then

Line 3331: from dual

3327: l_ee_id :=
3328: l_element_entry_id;
3329: select ''
3330: into l_dummy
3331: from dual
3332: where exists (select ''
3333: from pay_element_entry_values_f
3334: where element_entry_id = l_ee_id
3335: and element_entry_value_id = p_surrogate_key

Line 4812: from dual

4808: cursor validate_rate_by_criteria(p_assignment_id in number,
4809: p_surrogate_key in number)
4810: is
4811: select '' chk
4812: from dual
4813: where exists (
4814: select '' chk
4815: from pay_element_entries_f pee
4816: ,pqh_criteria_rate_elements pcre