APPS.PAY_JP_DEF_SS dependencies on DUAL

Line 41: from dual

37: l_datetrack_mode varchar2(30);
38: l_exists varchar2(1);
39: cursor csr_future_exists is
40: select 'Y'
41: from dual
42: where exists(
43: select null
44: from pay_element_entries_f
45: where element_entry_id = p_element_entry_id

Line 75: from dual

71: l_datetrack_mode varchar2(30);
72: l_exists varchar2(1);
73: cursor csr_future_exists is
74: select 'Y'
75: from dual
76: where exists(
77: select null
78: from per_contact_extra_info_f
79: where contact_extra_info_id = p_contact_extra_info_id

Line 109: from dual

105: l_datetrack_mode varchar2(30);
106: l_exists varchar2(1);
107: cursor csr_past_exists is
108: select 'Y'
109: from dual
110: where exists(
111: select null
112: from per_contact_extra_info_f
113: where contact_extra_info_id = p_contact_extra_info_id

Line 1607: from dual

1603: --
1604: cursor csr_married_flag(p_person_id number)
1605: is
1606: select 'Y' married_flag
1607: from dual
1608: where exists(
1609: select null
1610: from per_contact_relationships ctr
1611: where ctr.person_id = p_person_id