APPS.AMS_GEN_APPROVAL_PVT dependencies on AMS_APPROVERS

Line 183: FROM ams_approvers

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

Line 230: FROM ams_approvers

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

Line 403: FROM ams_approvers

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

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

639: FROM ams_approval_details
640: WHERE approval_detail_id = 150;
641: -- WHERE seeded_flag = 'Y'; -- to avoid FTS
642:
643: -- Takes Min Approver Sequence From Ams_approvers Once matching records are
644: -- Found from ams_approval_deatils
645: CURSOR c_approver_seq IS
646: SELECT min(approver_seq)
647: FROM ams_approvers

Line 647: FROM ams_approvers

643: -- Takes Min Approver Sequence From Ams_approvers Once matching records are
644: -- Found from ams_approval_deatils
645: CURSOR c_approver_seq IS
646: SELECT min(approver_seq)
647: FROM ams_approvers
648: WHERE ams_approval_detail_id = x_approval_detail_id
649: AND active_flag = 'Y'
650: AND TRUNC(sysdate) between TRUNC(nvl(start_date_active,sysdate -1 ))
651: AND TRUNC(nvl(end_date_active,sysdate + 1));

Line 1381: FROM ams_approvers

1377: l_note VARCHAR2(4000);
1378:
1379: CURSOR c_approver(rule_id IN NUMBER) IS
1380: SELECT approver_seq, approver_type, object_approver_id
1381: FROM ams_approvers
1382: WHERE ams_approval_detail_id = rule_id
1383: AND active_flag = 'Y'
1384: -- Bug 3558516 No trunc for start_date_active
1385: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE -1 ))