DBA Data[Home] [Help]

APPS.AS_GAR_LEADS_PUB dependencies on AS_STATUSES_B

Line 1043: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS

1039: ,l_org_id(i)
1040: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1041: ,L.lead_rank_score
1042: ,L.creation_date
1043: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS
1044: WHERE L.sales_lead_id = l_sales_lead_id(i)
1045: AND L.status_code = STS.status_code
1046: AND NOT EXISTS ( SELECT 'X'
1047: FROM AS_ACCESSES_ALL_ALL AA

Line 1118: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS

1114: ,l_org_id(i)
1115: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1116: ,L.lead_rank_score
1117: ,L.creation_date
1118: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS
1119: WHERE L.sales_lead_id = l_sales_lead_id(i)
1120: AND L.status_code = STS.status_code
1121: AND NOT EXISTS ( SELECT 'X'
1122: FROM AS_ACCESSES_ALL_ALL AA