APPS.PV_WORKFLOW_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 975: jtf_rs_resource_extns b

971: pc_itemkey varchar2) is
972: select
973: b.resource_id partner_org_rs_id
974: from pv_lead_assignments la,
975: jtf_rs_resource_extns b
976: where
977: la.wf_item_type = pc_itemtype
978: and la.wf_item_key = pc_itemkey
979: and la.status = pv_assignment_pub.g_la_status_cm_app_for_pt

Line 1267: jtf_rs_resource_extns b

1263: cursor lc_get_pt_org (pc_itemtype varchar2,
1264: pc_itemkey varchar2) is
1265: select b.resource_id partner_org_rs_id
1266: from pv_lead_assignments la,
1267: jtf_rs_resource_extns b
1268: where
1269: la.wf_item_type = pc_itemtype
1270: and la.wf_item_key = pc_itemkey
1271: and la.status = pv_assignment_pub.g_la_status_pt_timeout

Line 1280: jtf_rs_resource_extns b

1276: cursor lc_get_pt_lc_org (pc_itemtype varchar2,
1277: pc_itemkey varchar2) is
1278: select b.resource_id partner_org_rs_id
1279: from pv_lead_assignments la,
1280: jtf_rs_resource_extns b
1281: where
1282: la.wf_item_type = pc_itemtype
1283: and la.wf_item_key = pc_itemkey
1284: and la.status = pv_assignment_pub.g_la_status_lost_chance

Line 1293: jtf_rs_resource_extns b

1289: pc_itemkey varchar2) is
1290: select
1291: b.resource_id partner_org_rs_id
1292: from pv_lead_assignments la,
1293: jtf_rs_resource_extns b
1294: where
1295: la.wf_item_type = pc_itemtype
1296: and la.wf_item_key = pc_itemkey
1297: and la.status in (pv_assignment_pub.g_la_status_cm_app_for_pt,

Line 3089: jtf_rs_resource_extns g

3085: end person_name
3086: from
3087: PV_LEAD_ASSIGNMENTS C,
3088: pv_oppty_routing_logs a,
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)