DBA Data[Home] [Help]

APPS.PV_ASSIGNMENT_PVT dependencies on PV_LOOKUPS

Line 3013: from pv_lookups

3009:
3010: cursor lc_code_meaning (pc_lookup_type varchar2,
3011: pc_lookup_code varchar2) is
3012: select meaning
3013: from pv_lookups
3014: where lookup_type = pc_lookup_type
3015: and lookup_code = pc_lookup_code;
3016:
3017: l_routing_status varchar2(300);

Line 3561: pv_lookups b

3557: pc_itemtype varchar2,
3558: pc_itemkey varchar2) is
3559: select b.meaning
3560: from pv_lead_assignments a,
3561: pv_lookups b
3562: where a.wf_item_type = pc_itemtype
3563: and a.wf_item_key = pc_itemkey
3564: and a.partner_id = pc_partner_id
3565: and a.reason_code = b.lookup_code