APPS.QPR_WKFL_UTIL dependencies on QPR_LOOKUPS

Line 356: (select meaning from qpr_lookups

352: begin
353: select round(resp.deal_header_score,2), resp.version_number,
354: req.reference_name, req.customer_long_desc,
355: req.sales_rep_long_desc, req.currency_short_desc,
356: (select meaning from qpr_lookups
357: where lookup_type = 'PN_STATUS'
358: and lookup_code = resp.response_status and rownum < 2),
359: resp.description, req.deal_creation_date , req.request_header_id
360: into l_hdr_score, l_version_no, l_ref_name,

Line 527: (select meaning from qpr_lookups

523: begin
524: select round(resp.deal_header_score, 2), resp.version_number,
525: req.reference_name, req.customer_long_desc,
526: req.sales_rep_long_desc, req.currency_short_desc,
527: (select meaning from qpr_lookups
528: where lookup_type = 'PN_STATUS'
529: and lookup_code = resp.response_status and rownum < 2),
530: resp.description, req.deal_creation_date ,
531: resp.request_header_id

Line 931: select meaning into l_status from qpr_lookups where lookup_type = 'AME_STATUS'

927: wf_engine.SetItemAttrText(QPR_NTFN_ITM_TYPE , l_item_key,'QPR_COMMENTS',
928: p_comments);
929:
930: if p_status = 'APPROVE' then
931: select meaning into l_status from qpr_lookups where lookup_type = 'AME_STATUS'
932: and lookup_code = p_status;
933:
934: wf_engine.SetItemAttrText(QPR_NTFN_ITM_TYPE, l_item_key,'QPR_PN_RESP_STATUS',
935: l_status);

Line 937: select meaning into l_status from qpr_lookups where lookup_type = 'AME_STATUS'

933:
934: wf_engine.SetItemAttrText(QPR_NTFN_ITM_TYPE, l_item_key,'QPR_PN_RESP_STATUS',
935: l_status);
936: elsif p_status = 'REJECT' then
937: select meaning into l_status from qpr_lookups where lookup_type = 'AME_STATUS'
938: and lookup_code = p_status;
939:
940: wf_engine.SetItemAttrText(QPR_NTFN_ITM_TYPE, l_item_key,'QPR_PN_RESP_STATUS',
941: l_status);