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 4814: from dual

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

Line 4842: FROM dual

4838: cursor validate_input_value_id(p_assignment_id in number,
4839: p_surrogate_key in number)
4840: is
4841: SELECT '' chk
4842: FROM dual
4843: WHERE EXISTS
4844: (
4845: SELECT '' chk
4846: FROM pay_input_values_f piv

Line 4860: FROM dual

4856: cursor val_entl_line_elig(p_assignment_id in number,
4857: p_surrogate_key in number)
4858: is
4859: SELECT '' chk
4860: FROM dual
4861: WHERE EXISTS
4862: (
4863: SELECT '' chk
4864: FROM per_cagr_entitlement_lines_f cagr_lines