APPS.AMS_APPROVAL_PVT dependencies on AMS_APPROVAL_DETAILS

Line 1163: FROM ams_approval_details_vl

1159: AND TRUNC(NVL(rr.end_date_active,SYSDATE));
1160:
1161: CURSOR c_rule_name IS
1162: SELECT name
1163: FROM ams_approval_details_vl
1164: WHERE approval_detail_id = p_approval_detail_id;
1165:
1166: l_count NUMBER;
1167:

Line 1316: FROM ams_approval_details

1312: l_appr_detl_stmt1 VARCHAR2(4000):=' SELECT approval_detail_id,
1313: currency_code,
1314: nvl(approval_limit_from,0),
1315: nvl(approval_limit_to, :amount)
1316: FROM ams_approval_details
1317: WHERE NVL(business_unit_id,:businessunit) =:businessunit ' ;
1318:
1319: l_appr_detl_stmt2 VARCHAR2(4000):=' AND NVL(custom_setup_id,:customsetupid) =:customsetupid
1320: AND approval_object =:appobject AND approval_type =:apptype

Line 1346: FROM ams_approval_details

1342: SELECT approval_detail_id,
1343: currency_code,
1344: nvl(approval_limit_from,0),
1345: nvl(approval_limit_to, amount)
1346: FROM ams_approval_details
1347: WHERE NVL(business_unit_id,l_business_unit_id) = l_business_unit_id
1348: AND NVL(organization_id,l_org_id) = l_org_id
1349: AND NVL(custom_setup_id,l_setup_type_id) = l_setup_type_id
1350: AND approval_object = p_activity_type

Line 1370: FROM ams_approval_details

1366:
1367: -- If the there are no matching records it takes the default Rule
1368: CURSOR c_approver_def IS
1369: SELECT approval_detail_id
1370: FROM ams_approval_details
1371: WHERE approval_detail_id = 150;
1372: -- WHERE seeded_flag = 'Y'; -- to avoid FTS
1373:
1374: -- Takes Min Approver Sequence From Ams_approvers Once matching records are