eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PMV_APPROVALS_PVT dependencies on FND_LOOKUP_VALUES

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 47: and n.status='OPEN' and n.message_type in (SELECT lookup_code FROM fnd_lookup_values WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES')

43: FROM wf_notifications n, wf_notification_attributes a
44: where n.notification_id = a.notification_id
45: AND ( (n.more_info_role is null)
46: AND (n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)))
47: and n.status='OPEN' and n.message_type in (SELECT lookup_code FROM fnd_lookup_values WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES')
48: group by n.message_type;
49:
50: CURSOR get_more_notifications IS
51: SELECT n.message_type, count(distinct n.notification_id)

Line 55: and n.status='OPEN' and n.message_type in (SELECT lookup_code FROM fnd_lookup_values WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES')

51: SELECT n.message_type, count(distinct n.notification_id)
52: FROM wf_notifications n, wf_notification_attributes a
53: where n.notification_id = a.notification_id AND
54: (n.more_info_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME))
55: and n.status='OPEN' and n.message_type in (SELECT lookup_code FROM fnd_lookup_values WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES')
56: group by n.message_type;
57:
58: BEGIN
59: l_exp_url := '''pFunctionName=BIS_PMV_APPROVALS_DETAIL&pParamIds=Y&APPR_STATUS+APPR_STATUS=OPEN&DBI_OBJ_TYPE=BIS_NOTIFY_PROMPT''';

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