APPS.PAY_JP_SOE_PKG dependencies on DUAL

Line 51: from dual

47: IS
48: l_messages_exist VARCHAR2(1);
49: CURSOR csr_messages_exist IS
50: select 'Y'
51: from dual
52: where exists(
53: select NULL
54: from pay_message_lines pml
55: where pml.source_id = p_source_id

Line 87: from dual

83: --l_use_advanced_retropay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE;
84:
85: CURSOR csr_retro_entries_processed IS
86: select 'N'
87: from dual
88: where exists(
89: select 1
90: from pay_run_results prr,
91: pay_element_entries_f pee,

Line 112: from dual

108: ----------START-------------
109:
110: CURSOR csr_adv_ret_entries_processed IS
111: select 'N'
112: from dual
113: where exists(
114: select 1
115: from pay_run_results prr,
116: pay_element_entries_f pee,