[Home] [Help]
2632: document_type in out nocopy varchar2) IS
2633:
2634: -- ----------------------------------------------------------------------------------
2635: -- pklin
2636: -- Eliminated reference to wf_notifications from all the queries
2637: -- ----------------------------------------------------------------------------------
2638: cursor lc_get_products (pc_entity_id number, pc_notification_id number) is
2639: select c.CONCAT_CAT_PARENTAGE, decode(nvl(b.total_amount,0),0,'', b.total_amount || ' ' || a.currency_code) amount
2640: from as_leads_all a, as_lead_lines_all b, eni_prod_den_hrchy_parents_v c
3044: HR_ALL_ORGANIZATION_UNITS_TL h
3045: where
3046: c.wf_item_type = 'PVASGNMT'
3047: and c.wf_item_key = (select substr(context,10,LENGTH(CONTEXT)-10)
3048: from wf_notifications where notification_id = pc_notification)
3049: and c.partner_id = pc_partner_id
3050: and c.lead_assignment_id = a.lead_assignment_id
3051: and a.user_response in ('PT_APPROVED', 'CM_APP_FOR_PT')
3052: and c.partner_id = d.partner_id
3089: jtf_rs_resource_extns g
3090: where
3091: c.wf_item_type = 'PVASGNMT'
3092: and c.wf_item_key = (select substr(context,10,LENGTH(CONTEXT)-10)
3093: from wf_notifications where notification_id = pc_notification)
3094: and c.partner_id = pc_partner_id
3095: and c.lead_assignment_id = a.lead_assignment_id
3096: and a.user_response in ('PT_APPROVED', 'CM_APP_FOR_PT')
3097: and nvl(a.vendor_user_id, a.pt_contact_user_id) = g.user_id (+);