APPS.AMS_APPROVAL_PVT dependencies on AMS_APPROVAL_DETAILS

Line 1127: FROM ams_approval_details_vl

1123: AND TRUNC(NVL(rr.end_date_active,SYSDATE));
1124:
1125: CURSOR c_rule_name IS
1126: SELECT name
1127: FROM ams_approval_details_vl
1128: WHERE approval_detail_id = p_approval_detail_id;
1129:
1130: l_count NUMBER;
1131:

Line 1280: FROM ams_approval_details

1276: l_appr_detl_stmt1 VARCHAR2(4000):=' SELECT approval_detail_id,
1277: currency_code,
1278: nvl(approval_limit_from,0),
1279: nvl(approval_limit_to, :amount)
1280: FROM ams_approval_details
1281: WHERE NVL(business_unit_id,:businessunit) =:businessunit ' ;
1282:
1283: l_appr_detl_stmt2 VARCHAR2(4000):=' AND NVL(custom_setup_id,:customsetupid) =:customsetupid
1284: AND approval_object =:appobject AND approval_type =:apptype

Line 1310: FROM ams_approval_details

1306: SELECT approval_detail_id,
1307: currency_code,
1308: nvl(approval_limit_from,0),
1309: nvl(approval_limit_to, amount)
1310: FROM ams_approval_details
1311: WHERE NVL(business_unit_id,l_business_unit_id) = l_business_unit_id
1312: AND NVL(organization_id,l_org_id) = l_org_id
1313: AND NVL(custom_setup_id,l_setup_type_id) = l_setup_type_id
1314: AND approval_object = p_activity_type

Line 1334: FROM ams_approval_details

1330:
1331: -- If the there are no matching records it takes the default Rule
1332: CURSOR c_approver_def IS
1333: SELECT approval_detail_id
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