APPS.PV_ASSIGNMENT_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 151: jtf_rs_resource_extns extn

147: select extn.category,
148: extn.source_id,
149: fuser.user_id
150: from fnd_user fuser,
151: jtf_rs_resource_extns extn
152: where fuser.user_name = pc_username
153: and fuser.user_id = extn.user_id;
154:
155: cursor lc_get_am_org (pc_user_source_id number) is

Line 227: FROM jtf_rs_resource_extns

223: -- Start : Rivendell changes
224: CURSOR get_resource_id ( pc_partner_id NUMBER)
225: IS
226: SELECT resource_id
227: FROM jtf_rs_resource_extns
228: WHERE source_id = pc_partner_id
229: AND category = 'PARTNER';
230: -- End : Rivendell changes
231:

Line 2024: jtf_rs_resource_extns b

2020: cursor lc_get_pt_org (pc_itemtype varchar2,
2021: pc_itemkey varchar2) is
2022: select b.resource_id partner_org_rs_id
2023: from pv_lead_assignments la,
2024: jtf_rs_resource_extns b
2025: where
2026: la.wf_item_type = pc_itemtype
2027: and la.wf_item_key = pc_itemkey
2028: and la.status = pv_assignment_pub.g_la_status_pt_rejected

Line 2866: , jtf_rs_resource_extns extn

2862: SELECT extn.category
2863: , extn.source_id
2864: , pwf.created_by
2865: FROM pv_lead_workflows pwf
2866: , jtf_rs_resource_extns extn
2867: WHERE pwf.created_by = extn.user_id
2868: AND pwf.entity = 'OPPORTUNITY'
2869: AND pwf.latest_routing_flag = 'Y'
2870: AND pwf.lead_id = pc_lead_id;

Line 3449: jtf_rs_resource_extns re,

3445: la.lead_assignment_id,
3446: fu.user_id,
3447: re.resource_id
3448: from fnd_user fu,
3449: jtf_rs_resource_extns re,
3450: hz_relationships emp,
3451: pv_partner_profiles pt,
3452: pv_lead_assignments la
3453: where fu.user_name = pc_user_name

Line 3509: , jtf_rs_resource_extns extn

3505: SELECT extn.category
3506: , extn.source_id
3507: , pwf.created_by
3508: FROM pv_lead_workflows pwf
3509: , jtf_rs_resource_extns extn
3510: WHERE pwf.created_by = extn.user_id
3511: AND pwf.entity = 'OPPORTUNITY'
3512: AND pwf.latest_routing_flag = 'Y'
3513: AND pwf.lead_id = pc_lead_id;