APPS.AMS_APPROVERS_PVT dependencies on AMS_APPROVAL_DETAILS

Line 1150: FROM AMS_APPROVAL_DETAILS

1146: l_start_date DATE;
1147: l_end_date DATE;
1148: CURSOR get_parent_date (id_in IN NUMBER)IS
1149: SELECT START_DATE_ACTIVE, END_DATE_ACTIVE
1150: FROM AMS_APPROVAL_DETAILS
1151: WHERE APPROVAL_DETAIL_ID = id_in;
1152:
1153: BEGIN
1154: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1448: SELECT start_date_active , end_date_active FROM ams_approval_details

1444: l_end_date DATE;
1445:
1446:
1447: CURSOR c_approval_rule IS
1448: SELECT start_date_active , end_date_active FROM ams_approval_details
1449: WHERE approval_detail_id = p_approvers_rec.ams_approval_detail_id;
1450:
1451: BEGIN
1452:

Line 1558: SELECT start_date_active , end_date_active FROM ams_approval_details

1554: l_end_date_ar DATE;
1555:
1556:
1557: CURSOR c_approval_rule IS
1558: SELECT start_date_active , end_date_active FROM ams_approval_details
1559: WHERE approval_detail_id = p_approvers_rec.ams_approval_detail_id;
1560:
1561: CURSOR c_approver IS
1562: SELECT start_date_active , end_date_active FROM ams_approvers

Line 1698: FROM ams_approval_details

1694: l_proc_name VARCHAR2(80);
1695:
1696: CURSOR c_approval_rule IS
1697: SELECT approval_object, approval_type
1698: FROM ams_approval_details
1699: WHERE approval_detail_id = p_approvers_rec.ams_approval_detail_id;
1700:
1701: CURSOR c_obj_rule IS
1702: SELECT seeded_flag, package_name, procedure_name