APPS.BIS_PMV_APPROVALS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 39: SELECT lookup_code, meaning FROM fnd_lookup_values_vl WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES';

35: l_first boolean;
36: l_len NUMBER;
37:
38: CURSOR getApprovalTypes is
39: SELECT lookup_code, meaning FROM fnd_lookup_values_vl WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES';
40:
41: CURSOR get_Notifications IS
42: SELECT n.message_type, count(distinct n.notification_id)
43: FROM wf_notifications n, wf_notification_attributes a

Line 199: SELECT lookup_code FROM fnd_lookup_values_vl WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES';

195: l_more_where_clause VARCHAR2(500);
196: l_isOpen boolean;
197: --l_req_url varchar2(1000);
198: cursor getApprovalTypes is
199: SELECT lookup_code FROM fnd_lookup_values_vl WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES';
200: BEGIN
201: FOR i in 1..p_page_parameter_tbl.COUNT
202: LOOP
203: IF (p_page_parameter_tbl(i).parameter_name = 'APPR_STATUS+APPR_STATUS') THEN