DBA Data[Home] [Help]

APPS.PV_WORKFLOW_PUB dependencies on FND_USER

Line 1223: fnd_user usr

1219: pc_notify_type varchar2) is
1220: select usr.user_name, pn.resource_id
1221: from pv_lead_assignments la,
1222: pv_party_notifications pn,
1223: fnd_user usr
1224: where la.wf_item_type = pc_itemtype
1225: and la.wf_item_key = pc_itemkey
1226: and la.partner_id = pc_partner_id
1227: and la.lead_assignment_id = pn.lead_assignment_id

Line 1239: fnd_user usr

1235: pc_notify_type varchar2) is
1236: select usr.user_name, pn.resource_id
1237: from pv_lead_assignments la,
1238: pv_party_notifications pn,
1239: fnd_user usr
1240: where la.wf_item_type = pc_itemtype
1241: and la.wf_item_key = pc_itemkey
1242: and la.partner_id = pc_partner_id
1243: and la.lead_assignment_id = pn.lead_assignment_id

Line 3002: fnd_user b,

2998:
2999: CURSOR lc_get_vendor_org_name (pc_entity_id NUMBER) IS
3000: SELECT otl.name vendor_name
3001: FROM pv_lead_workflows a,
3002: fnd_user b,
3003: hr_all_organization_units o,
3004: hr_all_organization_units_tl otl,
3005: per_all_people_f p
3006: WHERE a.lead_id = pc_entity_id AND