APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on JTF_TAE_1600_CUST_WINNERS

Line 171: FROM JTF_TAE_1600_CUST_WINNERS WIN,

167: nvl(WIN.GROUP_ID,-777) GROUP_ID,
168: nvl(WIN.org_id,-777) org_id,
169: win.resource_type,
170: ACC.COLLECTOR_ID
171: FROM JTF_TAE_1600_CUST_WINNERS WIN,
172: AR_COLLECTORS ACC,
173: JTF_RS_ROLE_RELATIONS jtrr,
174: JTF_RS_ROLES_B jtr
175: WHERE WIN.SOURCE_ID = -1600

Line 365: FROM JTF_TAE_1600_CUST_WINNERS WIN,

361: nvl(WIN.GROUP_ID,-777) GROUP_ID,
362: nvl(WIN.org_id,-777) org_id,
363: win.resource_type,
364: ACC.COLLECTOR_ID
365: FROM JTF_TAE_1600_CUST_WINNERS WIN,
366: AR_COLLECTORS ACC,
367: JTF_RS_ROLE_RELATIONS jtrr,
368: JTF_RS_ROLES_B jtr
369: WHERE WIN.SOURCE_ID = -1600

Line 564: FROM JTF_TAE_1600_CUST_WINNERS WIN,

560: win.resource_type,
561: ACC.COLLECTOR_ID,
562: cust_acct.cust_account_id,
563: hzp.SITE_USE_ID
564: FROM JTF_TAE_1600_CUST_WINNERS WIN,
565: AR_COLLECTORS ACC,
566: JTF_RS_ROLE_RELATIONS jtrr,
567: JTF_RS_ROLES_B jtr,
568: HZ_CUST_SITE_USES_ALL hzp,

Line 609: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,

605: win.resource_type,
606: ACC.COLLECTOR_ID,
607: acct_site.cust_account_id,
608: hzp.SITE_USE_ID
609: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,
610: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,
611: HZ_CUST_SITE_USES hzp,
612: HZ_CUST_ACCT_SITES acct_site
613: WHERE WIN.SOURCE_ID = -1600

Line 841: FROM JTF_TAE_1600_CUST_WINNERS WIN,

837: nvl(WIN.GROUP_ID,-777) GROUP_ID,
838: nvl(WIN.org_id,-777) org_id,
839: win.resource_type,
840: WIN.PERSON_ID
841: FROM JTF_TAE_1600_CUST_WINNERS WIN,
842: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr
843: WHERE WIN.SOURCE_ID = -1600
844: AND WIN.worker_id = c_worker_id
845: AND WIN.RESOURCE_TYPE IN ('RS_EMPLOYEE', 'RS_GROUP')

Line 1081: FROM JTF_TAE_1600_CUST_WINNERS WIN,

1077: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1078:
1079: CURSOR c_MissedProfiles(c_worker_id number) IS
1080: SELECT WIN.TRANS_OBJECT_id
1081: FROM JTF_TAE_1600_CUST_WINNERS WIN,
1082: AR_COLLECTORS ACC,
1083: JTF_RS_ROLE_RELATIONS jtrr,
1084: JTF_RS_ROLES_B jtr
1085: WHERE WIN.SOURCE_ID = -1600

Line 1302: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,

1298:
1299: CURSOR c_MissedProfiles(c_worker_id number) IS
1300: SELECT win.trans_object_id, hzp.SITE_USE_ID,
1301: acct_site.cust_account_id
1302: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,
1303: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,
1304: HZ_CUST_SITE_USES hzp,
1305: HZ_CUST_ACCT_SITES acct_site
1306: WHERE WIN.SOURCE_ID = -1600