APPS.PV_PARTNER_PGM_TYPE_PVT dependencies on DUAL

Line 75: FROM dual;

71:
72: -- Cursor to get the sequence for pv_partner_program_type_b
73: CURSOR c_partner_prgm_type_id_seq IS
74: SELECT PV_PARTNER_PROGRAM_TYPE_B_S.NEXTVAL
75: FROM dual;
76:
77: -- Cursor to validate the uniqueness
78: CURSOR c_ptr_prgm_type_id_seq_exists (l_id IN NUMBER) IS
79: SELECT 'X'

Line 1443: SELECT 'x' FROM DUAL WHERE EXISTS (

1439: l_inactive BOOLEAN := TRUE;
1440: l_exists VARCHAR2(1);
1441:
1442: CURSOR partner_program_cur(l_program_type_id in number) is
1443: SELECT 'x' FROM DUAL WHERE EXISTS (
1444: SELECT 'x' FROM PV_PARTNER_PROGRAM_B
1445: WHERE PROGRAM_TYPE_ID = l_program_type_id
1446: AND PROGRAM_STATUS_CODE NOT IN ('CANCEL', 'CLOSED','ARCHIVE')
1447: AND ENABLED_FLAG = 'Y'

Line 1481: SELECT 'x' FROM DUAL WHERE EXISTS (

1477: l_delete BOOLEAN := TRUE;
1478: l_exists VARCHAR2(1);
1479:
1480: CURSOR partner_program_cur(l_program_type_id in number) is
1481: SELECT 'x' FROM DUAL WHERE EXISTS (
1482: SELECT 'x' FROM PV_PARTNER_PROGRAM_B
1483: WHERE PROGRAM_TYPE_ID = l_program_type_id
1484: AND ENABLED_FLAG = 'Y'
1485: );