APPS.AMS_APPROVAL_PVT dependencies on AMS_APPROVERS

Line 65: FROM ams_approvers

61: p_sequence IN NUMBER)
62: RETURN BOOLEAN IS
63: CURSOR c_min_seq IS
64: SELECT min(approver_seq)
65: FROM ams_approvers
66: WHERE ams_approval_detail_id = p_approval_detail_id
67: AND active_flag = 'Y'
68: AND TRUNC(sysdate) between TRUNC(nvl(start_date_active,sysdate -1 ))
69: AND TRUNC(nvl(end_date_active,sysdate + 1));

Line 1004: FROM ams_approvers

1000: IS
1001:
1002: CURSOR c_check_app IS
1003: SELECT approver_seq
1004: FROM ams_approvers
1005: WHERE ams_approval_detail_id = p_approval_detail_id
1006: AND approver_seq > p_current_seq
1007: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE -1 ))
1008: AND TRUNC(NVL(end_date_active,SYSDATE + 1))

Line 1065: FROM ams_approvers

1061: , approver_type
1062: , object_approver_id
1063: , notification_type
1064: , notification_timeout
1065: FROM ams_approvers
1066: WHERE ams_approval_detail_id = p_approval_detail_id
1067: AND approver_seq = p_current_seq
1068: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE-1 ))
1069: AND TRUNC(NVL(end_date_active,SYSDATE + 1))

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

1334: FROM ams_approval_details
1335: WHERE approval_detail_id = 150;
1336: -- WHERE seeded_flag = 'Y'; -- to avoid FTS
1337:
1338: -- Takes Min Approver Sequence From Ams_approvers Once matching records are
1339: -- Found form ams_approval_deatils
1340: CURSOR c_approver_seq IS
1341: SELECT MIN(approver_seq)
1342: FROM ams_approvers

Line 1342: FROM ams_approvers

1338: -- Takes Min Approver Sequence From Ams_approvers Once matching records are
1339: -- Found form ams_approval_deatils
1340: CURSOR c_approver_seq IS
1341: SELECT MIN(approver_seq)
1342: FROM ams_approvers
1343: WHERE ams_approval_detail_id = x_approval_detail_id
1344: AND TRUNC(SYSDATE) BETWEEN
1345: TRUNC(NVL(start_date_active,SYSDATE -1 )) AND TRUNC(NVL(end_date_active,SYSDATE + 1))
1346: AND active_flag = 'Y';

Line 2542: FROM ams_approvers

2538: WHERE OBJECT_RULE_ID = rule_id_in;
2539:
2540: CURSOR c_approver(rule_id IN NUMBER) IS
2541: SELECT approver_seq, approver_type, object_approver_id
2542: FROM ams_approvers
2543: WHERE ams_approval_detail_id = rule_id
2544: AND active_flag = 'Y'
2545: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE -1 ))
2546: AND TRUNC(NVL(end_date_active,SYSDATE + 1));

Line 4773: FROM ams_approvers

4769:
4770: -- 11.5.9
4771: CURSOR c_approver(rule_id IN NUMBER) IS
4772: SELECT approver_seq, approver_type, object_approver_id
4773: FROM ams_approvers
4774: WHERE ams_approval_detail_id = rule_id
4775: AND active_flag = 'Y'
4776: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE -1 ))
4777: AND TRUNC(NVL(end_date_active,SYSDATE + 1));

Line 7652: from ams_approvers

7648: l_return_status VARCHAR2(1);
7649:
7650: CURSOR c_is_only_approver(id IN NUMBER) IS
7651: SELECT approver_type, object_approver_id
7652: from ams_approvers
7653: where ams_approval_detail_id = id
7654: and sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate)
7655: and active_flag = 'Y'
7656: and not exists (select count(approver_id) from ams_approvers

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

7652: from ams_approvers
7653: where ams_approval_detail_id = id
7654: and sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate)
7655: and active_flag = 'Y'
7656: and not exists (select count(approver_id) from ams_approvers
7657: where ams_approval_detail_id = id
7658: and sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate)
7659: and active_flag = 'Y'
7660: having count(approver_id) > 1);