APPS.AMS_GEN_APPROVAL_PVT dependencies on AMS_APPROVERS

Line 181: FROM ams_approvers

177: IS
178:
179: CURSOR c_check_app IS
180: SELECT approver_seq
181: FROM ams_approvers
182: WHERE ams_approval_detail_id = p_approval_detail_id
183: AND approver_seq > p_current_seq
184: and TRUNC(sysdate) between TRUNC(nvl(start_date_active,sysdate -1 ))
185: and TRUNC(nvl(end_date_active,sysdate + 1))

Line 228: FROM ams_approvers

224: approver_type,
225: object_approver_id,
226: notification_type,
227: notification_timeout
228: FROM ams_approvers
229: WHERE ams_approval_detail_id = p_approval_detail_id
230: AND approver_seq = p_current_seq
231: and TRUNC(sysdate) between TRUNC(nvl(start_date_active,sysdate -1 ))
232: and TRUNC(nvl(end_date_active,sysdate + 1))

Line 401: FROM ams_approvers

397: p_sequence IN NUMBER)
398: RETURN BOOLEAN IS
399: CURSOR c_min_seq IS
400: SELECT min(approver_seq)
401: FROM ams_approvers
402: WHERE ams_approval_detail_id = p_approval_detail_id
403: AND active_flag = 'Y'
404: AND TRUNC(sysdate) between TRUNC(nvl(start_date_active,sysdate -1 ))
405: AND TRUNC(nvl(end_date_active,sysdate + 1));

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

600: FROM ams_approval_details
601: WHERE approval_detail_id = 150;
602: -- WHERE seeded_flag = 'Y'; -- to avoid FTS
603:
604: -- Takes Min Approver Sequence From Ams_approvers Once matching records are
605: -- Found from ams_approval_deatils
606: CURSOR c_approver_seq IS
607: SELECT min(approver_seq)
608: FROM ams_approvers

Line 608: FROM ams_approvers

604: -- Takes Min Approver Sequence From Ams_approvers Once matching records are
605: -- Found from ams_approval_deatils
606: CURSOR c_approver_seq IS
607: SELECT min(approver_seq)
608: FROM ams_approvers
609: WHERE ams_approval_detail_id = x_approval_detail_id
610: AND active_flag = 'Y'
611: AND TRUNC(sysdate) between TRUNC(nvl(start_date_active,sysdate -1 ))
612: AND TRUNC(nvl(end_date_active,sysdate + 1));

Line 1268: FROM ams_approvers

1264: l_note VARCHAR2(4000);
1265:
1266: CURSOR c_approver(rule_id IN NUMBER) IS
1267: SELECT approver_seq, approver_type, object_approver_id
1268: FROM ams_approvers
1269: WHERE ams_approval_detail_id = rule_id
1270: AND active_flag = 'Y'
1271: -- Bug 3558516 No trunc for start_date_active
1272: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE -1 ))