APPS.AMS_APPROVAL_PVT dependencies on AMS_APPROVERS

Line 100: FROM ams_approvers

96: p_sequence IN NUMBER)
97: RETURN BOOLEAN IS
98: CURSOR c_min_seq IS
99: SELECT min(approver_seq)
100: FROM ams_approvers
101: WHERE ams_approval_detail_id = p_approval_detail_id
102: AND active_flag = 'Y'
103: AND TRUNC(sysdate) between TRUNC(nvl(start_date_active,sysdate -1 ))
104: AND TRUNC(nvl(end_date_active,sysdate + 1));

Line 1040: FROM ams_approvers

1036: IS
1037:
1038: CURSOR c_check_app IS
1039: SELECT approver_seq
1040: FROM ams_approvers
1041: WHERE ams_approval_detail_id = p_approval_detail_id
1042: AND approver_seq > p_current_seq
1043: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE -1 ))
1044: AND TRUNC(NVL(end_date_active,SYSDATE + 1))

Line 1101: FROM ams_approvers

1097: , approver_type
1098: , object_approver_id
1099: , notification_type
1100: , notification_timeout
1101: FROM ams_approvers
1102: WHERE ams_approval_detail_id = p_approval_detail_id
1103: AND approver_seq = p_current_seq
1104: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE-1 ))
1105: AND TRUNC(NVL(end_date_active,SYSDATE + 1))

Line 1374: -- Takes Min Approver Sequence From Ams_approvers Once matching records are

1370: FROM ams_approval_details
1371: WHERE approval_detail_id = 150;
1372: -- WHERE seeded_flag = 'Y'; -- to avoid FTS
1373:
1374: -- Takes Min Approver Sequence From Ams_approvers Once matching records are
1375: -- Found form ams_approval_deatils
1376: CURSOR c_approver_seq IS
1377: SELECT MIN(approver_seq)
1378: FROM ams_approvers

Line 1378: FROM ams_approvers

1374: -- Takes Min Approver Sequence From Ams_approvers Once matching records are
1375: -- Found form ams_approval_deatils
1376: CURSOR c_approver_seq IS
1377: SELECT MIN(approver_seq)
1378: FROM ams_approvers
1379: WHERE ams_approval_detail_id = x_approval_detail_id
1380: AND TRUNC(SYSDATE) BETWEEN
1381: TRUNC(NVL(start_date_active,SYSDATE -1 )) AND TRUNC(NVL(end_date_active,SYSDATE + 1))
1382: AND active_flag = 'Y';

Line 2578: FROM ams_approvers

2574: WHERE OBJECT_RULE_ID = rule_id_in;
2575:
2576: CURSOR c_approver(rule_id IN NUMBER) IS
2577: SELECT approver_seq, approver_type, object_approver_id
2578: FROM ams_approvers
2579: WHERE ams_approval_detail_id = rule_id
2580: AND active_flag = 'Y'
2581: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE -1 ))
2582: AND TRUNC(NVL(end_date_active,SYSDATE + 1));

Line 4864: FROM ams_approvers

4860:
4861: -- 11.5.9
4862: CURSOR c_approver(rule_id IN NUMBER) IS
4863: SELECT approver_seq, approver_type, object_approver_id
4864: FROM ams_approvers
4865: WHERE ams_approval_detail_id = rule_id
4866: AND active_flag = 'Y'
4867: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE -1 ))
4868: AND TRUNC(NVL(end_date_active,SYSDATE + 1));

Line 7743: from ams_approvers

7739: l_return_status VARCHAR2(1);
7740:
7741: CURSOR c_is_only_approver(id IN NUMBER) IS
7742: SELECT approver_type, object_approver_id
7743: from ams_approvers
7744: where ams_approval_detail_id = id
7745: and sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate)
7746: and active_flag = 'Y'
7747: and not exists (select count(approver_id) from ams_approvers

Line 7747: and not exists (select count(approver_id) from ams_approvers

7743: from ams_approvers
7744: where ams_approval_detail_id = id
7745: and sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate)
7746: and active_flag = 'Y'
7747: and not exists (select count(approver_id) from ams_approvers
7748: where ams_approval_detail_id = id
7749: and sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate)
7750: and active_flag = 'Y'
7751: having count(approver_id) > 1);