APPS.AS_SC_DENORM_TRG dependencies on JTF_RS_GROUPS_TL

Line 171: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;

167: l_competitor_name hz_parties.party_name%TYPE;
168: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
169: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
170: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
171: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
172: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
173: Begin
174: IF l_debug THEN
175: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Leads_Trigger_Handler Start');

Line 231: From jtf_rs_groups_tl

227:
228: Begin
229: Select group_name
230: Into l_owner_group_name
231: From jtf_rs_groups_tl
232: Where group_id = p_new_owner_sales_group_id
233: And language = userenv('LANG');
234: Exception When Others then
235: l_owner_group_name := Null;

Line 683: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;

679: l_competitor_name hz_parties.party_name%TYPE;
680: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
681: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
682: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
683: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
684: l_sales_stage as_sales_stages.name%TYPE;
685: l_win_probability as_leads_all.win_probability%TYPE;
686: l_status_code as_leads_all.status%TYPE;
687: l_sales_methodology_id as_leads_all.sales_methodology_id%TYPE;

Line 832: From jtf_rs_groups_tl

828:
829: Begin
830: Select group_name
831: Into l_sales_group_name
832: From jtf_rs_groups_tl
833: Where group_id = p_new_salesgroup_id
834: And language = userenv('LANG');
835: Exception When Others then
836: l_sales_group_name := Null;

Line 918: From jtf_rs_groups_tl

914:
915: Begin
916: Select group_name
917: Into l_owner_group_name
918: From jtf_rs_groups_tl
919: Where group_id = l_owner_sales_group_id
920: And language = userenv('LANG');
921: Exception When Others then
922: l_owner_group_name := Null;