APPS.PV_ASSIGN_UTIL_PVT dependencies on AS_LEADS_ALL

Line 75: FROM as_leads_all

71: CURSOR lc_chk_pf_pt ( pc_lead_id NUMBER
72: ,pc_partner_id NUMBER)
73: IS
74: SELECT 'X'
75: FROM as_leads_all
76: WHERE lead_id = pc_lead_id
77: AND incumbent_partner_party_id = pc_partner_id;
78:
79:

Line 85: FROM as_leads_all al

81: , pc_item_key VARCHAR2
82: , pc_item_type VARCHAR2)
83: IS
84: SELECT 'X'
85: FROM as_leads_all al
86: , pv_lead_assignments ass
87: WHERE al.lead_id = ass.lead_id
88: AND al.incumbent_partner_party_id = ass.partner_id
89: AND ass.wf_item_type = pc_item_type

Line 141: UPDATE as_leads_all

137: IF l_flag IS NOT NULL
138: AND p_lead_id IS NOT NULL
139: THEN
140:
141: UPDATE as_leads_all
142: SET incumbent_partner_party_id = NULL ,
143: incumbent_partner_resource_id = NULL
144: WHERE lead_id = p_lead_id;
145:

Line 200: select lead_number from as_leads_all where lead_id = pc_lead_id;

196: l_message_name varchar2(30);
197: l_log_params_tbl pvx_utility_pvt.log_params_tbl_type;
198:
199: cursor lc_get_opp_number (pc_lead_id number) is
200: select lead_number from as_leads_all where lead_id = pc_lead_id;
201:
202: l_lead_number varchar2(50);
203:
204: begin

Line 1705: from pv_lead_workflows wf, jtf_rs_resource_extns am, as_leads_all ld, jtf_rs_resource_extns owner

1701: and lead_id = pc_lead_id;
1702:
1703: cursor lc_get_am_and_owner (pc_lead_id number) is
1704: select am.resource_id, owner.resource_id
1705: from pv_lead_workflows wf, jtf_rs_resource_extns am, as_leads_all ld, jtf_rs_resource_extns owner
1706: where wf.lead_id = pc_lead_id
1707: and wf.entity = 'OPPORTUNITY'
1708: and wf.latest_routing_flag = 'Y'
1709: and wf.created_by = am.user_id

Line 1749: from as_leads_all ld, as_statuses_b st

1745: AND pn.notification_type = 'OFFERED_TO';
1746:
1747: cursor get_opp_open_flag_csr(pc_lead_id number) is
1748: select decode(st.opp_open_status_flag,'N',NULL,st.opp_open_status_flag)
1749: from as_leads_all ld, as_statuses_b st
1750: where ld.lead_id = pc_lead_id
1751: and ld.status = st.status_code;
1752:
1753: l_current_user_rs_id NUMBER; -- resource_id of currently logged in user