DBA Data[Home] [Help]

APPS.AS_GAR_LEADS_PUB dependencies on AS_STATUSES_B

Line 1084: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS

1080: ,l_org_id(i)
1081: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1082: ,L.lead_rank_score
1083: ,L.creation_date
1084: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS
1085: WHERE L.sales_lead_id = l_sales_lead_id(i)
1086: AND L.status_code = STS.status_code
1087: AND NOT EXISTS ( SELECT 'X'
1088: FROM AS_ACCESSES_ALL_ALL AA

Line 1159: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS

1155: ,l_org_id(i)
1156: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1157: ,L.lead_rank_score
1158: ,L.creation_date
1159: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS
1160: WHERE L.sales_lead_id = l_sales_lead_id(i)
1161: AND L.status_code = STS.status_code
1162: AND NOT EXISTS ( SELECT 'X'
1163: FROM AS_ACCESSES_ALL_ALL AA