APPS.AS_RTTAP_ACCOUNT dependencies on DUAL

Line 374: FROM DUAL

370: SYSDATE,
371: 0,
372: 0,
373: 'ACCOUNT'
374: FROM DUAL
375: WHERE NOT EXISTS
376: ( SELECT 'X'
377: FROM AS_CHANGED_ACCOUNTS_ALL ACC
378: WHERE ACC.customer_id = G_PARTY_ID

Line 631: AND tm.resource_type = 'INDIVIDUAL'

627: AND tu.team_id = t.team_id
628: AND tu.usage IN ('SALES','PRM')
629: AND tm.team_member_id = trr.role_resource_id
630: AND tm.delete_flag <> 'Y'
631: AND tm.resource_type = 'INDIVIDUAL'
632: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
633: AND trr.delete_flag <> 'Y'
634: AND SYSDATE BETWEEN trr.start_date_active
635: AND NVL(trr.end_date_active,SYSDATE)

Line 966: FROM DUAL

962: p_WinningTerrMember_tbl.resource_id(l_index) salesforce_id,
963: (SELECT source_id FROM JTF_RS_RESOURCE_EXTNS RES WHERE RES.resource_id = p_WinningTerrMember_tbl.resource_id(l_index)) person_id,
964: p_WinningTerrMember_tbl.group_id(l_index) sales_group_id,
965: 'Y' created_by_tap_flag
966: FROM DUAL
967: WHERE NOT EXISTS
968: ( SELECT NULL FROM AS_ACCESSES_ALL ACC
969: WHERE ACC.customer_id = G_PARTY_ID
970: AND ACC.lead_id IS NULL

Line 1027: FROM DUAL

1023: 'Y',
1024: DECODE(p_WinningTerrMember_tbl.resource_type(l_index),'RS_PARTNER',(SELECT source_id FROM JTF_RS_RESOURCE_EXTNS RES WHERE resource_id = p_WinningTerrMember_tbl.resource_id(l_index)),NULL),
1025: DECODE(p_WinningTerrMember_tbl.resource_type(l_index),'RS_PARTY',(SELECT source_id FROM JTF_RS_RESOURCE_EXTNS RES WHERE resource_id = p_WinningTerrMember_tbl.resource_id(l_index)),NULL),
1026: p_WinningTerrMember_tbl.org_id(l_index)
1027: FROM DUAL
1028: WHERE NOT EXISTS
1029: ( SELECT NULL FROM AS_ACCESSES_ALL ACC
1030: WHERE ACC.customer_id = G_PARTY_ID
1031: AND ACC.lead_id IS NULL