APPS.AS_JTF_RS_GROUP_MEM_TRG dependencies on AS_STATUSES_B

Line 93: from AS_LEADS_ALL ld, AS_STATUSES_B st

89: and nvl(acc2.address_id,-99) = nvl(acc.address_id,-99)
90: and nvl(acc2.org_id,-99) = nvl(acc.org_id,-99) )
91: and exists
92: ( select 1
93: from AS_LEADS_ALL ld, AS_STATUSES_B st
94: where acc.lead_id = ld.lead_id
95: and ld.status = st.status_code
96: and st.opp_open_status_flag = 'Y' );
97:

Line 105: from AS_LEADS_ALL ld, AS_STATUSES_B st

101: where sc.salesforce_id = x_new_resource_id
102: and sc.salesgroup_id = x_old_group_id
103: and exists
104: ( select 1
105: from AS_LEADS_ALL ld, AS_STATUSES_B st
106: where ld.status = st.status_code
107: and st.opp_open_status_flag = 'Y'
108: and sc.lead_id = ld.lead_id );
109:

Line 116: from AS_STATUSES_B st

112: where ld.owner_salesforce_id = x_new_resource_id
113: and ld.owner_sales_group_id = x_old_group_id
114: and exists
115: ( select 1
116: from AS_STATUSES_B st
117: where ld.status = st.status_code
118: and st.opp_open_status_flag = 'Y');
119:
120: ELSIF(l_opp_profile = 'ALL') THEN

Line 172: from AS_SALES_LEADS sl, AS_STATUSES_B st

168: and nvl(acc2.address_id,-99) = nvl(acc.address_id,-99)
169: and nvl(acc2.org_id,-99) = nvl(acc.org_id,-99) )
170: and exists
171: ( select 1
172: from AS_SALES_LEADS sl, AS_STATUSES_B st
173: where acc.sales_lead_id = sl.sales_lead_id
174: and sl.status_code = st.status_code
175: and st.opp_open_status_flag = 'Y' );
176:

Line 184: from AS_STATUSES_B st

180: where sl.assign_to_salesforce_id = x_new_resource_id
181: and sl.assign_sales_group_id = x_old_group_id
182: and exists
183: ( select 1
184: from AS_STATUSES_B st
185: where st.status_code = sl.status_code
186: and st.opp_open_status_flag = 'Y' );
187:
188: ELSIF(l_lead_profile = 'ALL') THEN