DBA Data[Home] [Help]

APPS.PV_WORKFLOW_PUB dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 3004: hr_all_organization_units_tl otl,

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
3007: a.created_by = b.user_id AND
3008: o.organization_id = otl.organization_id AND

Line 3044: HR_ALL_ORGANIZATION_UNITS_TL h

3040: PV_LEAD_ASSIGNMENTS C,
3041: pv_oppty_routing_logs a,
3042: pv_partner_profiles d,
3043: hz_parties e,
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)