APPS.PV_ASSIGNMENT_PUB dependencies on PV_LOOKUPS

Line 111: select meaning from pv_lookups

107: b.opp_flag = 'Y';
108:
109:
110: cursor lc_get_assign_type_meaning (pc_assignment_type varchar2) is
111: select meaning from pv_lookups
112: where lookup_type = 'PV_ASSIGNMENT_TYPE'
113: and lookup_code = pc_assignment_type;
114:
115: cursor lc_get_pt_org_name (pc_partner_id number) is

Line 1913: select lookup_code from pv_lookups

1909: l_partner_id_tab g_number_table_type := g_number_table_type();
1910: l_assignment_id_tab g_number_table_type := g_number_table_type();
1911:
1912: cursor lc_validate_reason (pc_lookup_type varchar2, pc_reason_code varchar2) is
1913: select lookup_code from pv_lookups
1914: where lookup_type = pc_lookup_type
1915: and lookup_code = pc_reason_code;
1916:
1917: cursor lc_get_pt_org_name (pc_partner_id number) is

Line 2856: FROM pv_lookups

2852:
2853: CURSOR lc_get_assign_type_meaning (pc_assignment_type varchar2)
2854: IS
2855: SELECT meaning
2856: FROM pv_lookups
2857: WHERE lookup_type = 'PV_ASSIGNMENT_TYPE'
2858: AND lookup_code = pc_assignment_type;
2859:
2860: CURSOR lc_get_vendor_cat(pc_lead_id NUMBER)

Line 3499: FROM pv_lookups

3495:
3496: CURSOR lc_get_assign_type_meaning (pc_assignment_type varchar2)
3497: IS
3498: SELECT meaning
3499: FROM pv_lookups
3500: WHERE lookup_type = 'PV_ASSIGNMENT_TYPE'
3501: AND lookup_code = pc_assignment_type;
3502:
3503: CURSOR lc_get_vendor_cat(pc_lead_id NUMBER)

Line 3782: FROM pv_lookups

3778: IF p_reason_code IS NOT NULL
3779: THEN
3780: SELECT meaning
3781: INTO l_action_reason
3782: FROM pv_lookups
3783: WHERE lookup_type = 'PV_REASON_CODES'
3784: AND lookup_code = p_reason_code;
3785: END IF;
3786: