APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on JTF_TAE_1600_CUST_WINNERS

Line 183: FROM JTF_TAE_1600_CUST_WINNERS WIN,

179: nvl(WIN.GROUP_ID,-777) GROUP_ID,
180: nvl(WIN.org_id,-777) org_id,
181: win.resource_type,
182: ACC.COLLECTOR_ID
183: FROM JTF_TAE_1600_CUST_WINNERS WIN,
184: AR_COLLECTORS ACC,
185: JTF_RS_ROLE_RELATIONS jtrr,
186: JTF_RS_ROLES_B jtr
187: WHERE WIN.SOURCE_ID = -1600

Line 398: FROM JTF_TAE_1600_CUST_WINNERS WIN,

394: nvl(WIN.GROUP_ID,-777) GROUP_ID,
395: nvl(WIN.org_id,-777) org_id,
396: win.resource_type,
397: ACC.COLLECTOR_ID
398: FROM JTF_TAE_1600_CUST_WINNERS WIN,
399: AR_COLLECTORS ACC,
400: JTF_RS_ROLE_RELATIONS jtrr,
401: JTF_RS_ROLES_B jtr
402: WHERE WIN.SOURCE_ID = -1600

Line 609: FROM JTF_TAE_1600_CUST_WINNERS WIN,

605: win.resource_type,
606: ACC.COLLECTOR_ID,
607: cust_acct.cust_account_id,
608: hzp.SITE_USE_ID
609: FROM JTF_TAE_1600_CUST_WINNERS WIN,
610: AR_COLLECTORS ACC,
611: JTF_RS_ROLE_RELATIONS jtrr,
612: JTF_RS_ROLES_B jtr,
613: HZ_CUST_SITE_USES_ALL hzp,

Line 654: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,

650: win.resource_type,
651: ACC.COLLECTOR_ID,
652: acct_site.cust_account_id,
653: hzp.SITE_USE_ID
654: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,
655: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,
656: HZ_CUST_SITE_USES hzp,
657: HZ_CUST_ACCT_SITES acct_site
658: WHERE WIN.SOURCE_ID = -1600

Line 899: FROM JTF_TAE_1600_CUST_WINNERS WIN,

895: nvl(WIN.GROUP_ID,-777) GROUP_ID,
896: nvl(WIN.org_id,-777) org_id,
897: win.resource_type,
898: WIN.PERSON_ID
899: FROM JTF_TAE_1600_CUST_WINNERS WIN,
900: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr
901: WHERE WIN.SOURCE_ID = -1600
902: AND WIN.worker_id = c_worker_id
903: AND WIN.RESOURCE_TYPE IN ('RS_EMPLOYEE', 'RS_GROUP')

Line 1139: FROM JTF_TAE_1600_CUST_WINNERS WIN,

1135: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1136:
1137: CURSOR c_MissedProfiles(c_worker_id number) IS
1138: SELECT WIN.TRANS_OBJECT_id
1139: FROM JTF_TAE_1600_CUST_WINNERS WIN,
1140: AR_COLLECTORS ACC,
1141: JTF_RS_ROLE_RELATIONS jtrr,
1142: JTF_RS_ROLES_B jtr
1143: WHERE WIN.SOURCE_ID = -1600

Line 1364: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,

1360:
1361: CURSOR c_MissedProfiles(c_worker_id number) IS
1362: SELECT win.trans_object_id, hzp.SITE_USE_ID,
1363: acct_site.cust_account_id
1364: FROM JTF_TAE_1600_CUST_WINNERS WIN, AR_COLLECTORS ACC,
1365: JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtr,
1366: HZ_CUST_SITE_USES hzp,
1367: HZ_CUST_ACCT_SITES acct_site
1368: WHERE WIN.SOURCE_ID = -1600