APPS.AMS_GEN_APPROVAL_PVT dependencies on AMS_APPROVAL_DETAILS

Line 287: FROM ams_approval_details_vl

283: and TRUNC(nvl(rr.end_date_active,sysdate));
284:
285: CURSOR c_rule_name IS
286: SELECT name
287: FROM ams_approval_details_vl
288: WHERE approval_detail_id = p_approval_detail_id;
289:
290: l_count number;
291: l_pkg_name VARCHAR2(80);

Line 569: FROM ams_approval_details

565: -- custom_setup_id 1
566:
567: CURSOR c_approver_detail_id IS
568: SELECT approval_detail_id, seeded_flag
569: FROM ams_approval_details
570: WHERE nvl(business_unit_id,l_business_unit_id) = l_business_unit_id
571: AND nvl(organization_id,l_org_id) = l_org_id
572: AND nvl(custom_setup_id,l_setup_type_id) = l_setup_type_id
573: AND approval_object = p_activity_type

Line 600: FROM ams_approval_details

596: */
597: -- If the there are no matching records it takes the default Rule
598: CURSOR c_approver_def IS
599: SELECT approval_detail_id, seeded_flag
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

Line 634: FROM ams_approval_details

630:
631: BEGIN
632:
633: SELECT distinct organization_id into l_freq_org_id
634: FROM ams_approval_details
635: WHERE approval_object = p_activity_type
636: AND approval_type = p_approval_type
637: AND approval_object_type = p_object_details.object_type;
638: