APPS.PAY_JP_DEF_SS dependencies on DUAL

Line 34: from dual

30: l_datetrack_mode varchar2(30);
31: l_exists varchar2(1);
32: cursor csr_future_exists is
33: select 'Y'
34: from dual
35: where exists(
36: select null
37: from pay_element_entries_f
38: where element_entry_id = p_element_entry_id

Line 68: from dual

64: l_datetrack_mode varchar2(30);
65: l_exists varchar2(1);
66: cursor csr_future_exists is
67: select 'Y'
68: from dual
69: where exists(
70: select null
71: from per_contact_extra_info_f
72: where contact_extra_info_id = p_contact_extra_info_id

Line 102: from dual

98: l_datetrack_mode varchar2(30);
99: l_exists varchar2(1);
100: cursor csr_past_exists is
101: select 'Y'
102: from dual
103: where exists(
104: select null
105: from per_contact_extra_info_f
106: where contact_extra_info_id = p_contact_extra_info_id

Line 1317: from dual

1313: cursor csr_married_flag(
1314: p_person_id number,
1315: p_effective_date date) is
1316: select 'Y'
1317: from dual
1318: where exists(
1319: select null
1320: from per_contact_relationships ctr
1321: where ctr.person_id = p_person_id