APPS.PV_ENRQ_BINS_PVT dependencies on DUAL

Line 77: Select 'X' from dual

73: FUNCTION isGlobalEnrolled(p_program_id in NUMBER, p_subs_partner_id in number)
74: RETURN BOOLEAN IS
75:
76: CURSOR isenroll_csr(p_prgm_id NUMBER,p_global_ptr_id NUMBER) IS
77: Select 'X' from dual
78: WHERE EXISTS
79: (
80: select membership_id from pv_pg_memberships
81: where membership_status_code in ('ACTIVE','FUTURE')

Line 91: union select p_prgm_id FROM DUAL

87: AND ACTIVE_FLAG='Y'
88: START with change_from_program_id=p_prgm_id
89: CONNECT by CHANGE_FROM_PROGRAM_id=PRIOR CHANGE_to_program_id
90: and CHANGE_TO_PROGRAM_ID<>PRIOR CHANGE_FROM_PROGRAM_Id
91: union select p_prgm_id FROM DUAL
92: )
93: );
94:
95: