APPS.AMS_GEN_APPROVAL_PVT dependencies on AMS_APPROVAL_DETAILS

Line 289: FROM ams_approval_details_vl

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

Line 576: FROM ams_approval_details

572: -- custom_setup_id 1
573:
574: CURSOR c_approver_detail_id IS
575: SELECT approval_detail_id, seeded_flag
576: FROM ams_approval_details
577: WHERE nvl(business_unit_id,l_business_unit_id) = l_business_unit_id
578: AND nvl(organization_id,l_org_id) = l_org_id
579: AND nvl(custom_setup_id,l_setup_type_id) = l_setup_type_id
580: AND approval_object = p_activity_type

Line 601: FROM ams_approval_details

597: POWER(2,DECODE(approval_priority,'',0,4) )) DESC ;
598:
599: CURSOR c_groupclaim_approver_id IS --ninarasi fix for bug 13998589
600: SELECT approval_detail_id, seeded_flag
601: FROM ams_approval_details
602: WHERE nvl(business_unit_id,l_business_unit_id) = l_business_unit_id
603: AND nvl(organization_id,l_org_id) = l_org_id
604: AND custom_setup_id = l_setup_type_id
605: AND approval_object = p_activity_type

Line 639: FROM ams_approval_details

635: */
636: -- If the there are no matching records it takes the default Rule
637: CURSOR c_approver_def IS
638: SELECT approval_detail_id, seeded_flag
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

Line 682: FROM ams_approval_details

678:
679: BEGIN
680:
681: SELECT distinct organization_id into l_freq_org_id
682: FROM ams_approval_details
683: WHERE approval_object = p_activity_type
684: AND approval_type = p_approval_type
685: AND approval_object_type = p_object_details.object_type;
686:

Line 719: FROM ams_approval_details

715: IF (p_activity_type='CLAM') THEN
716: BEGIN
717:
718: SELECT distinct APPROVAL_OBJECT_TYPE into l_appr_obj_type
719: FROM ams_approval_details
720: WHERE approval_object = p_activity_type
721: AND approval_type = p_approval_type;
722:
723: EXCEPTION