APPS.OZF_CLAIM_APPROVAL_PVT dependencies on AMS_APPROVERS

Line 58: FROM ams_approvers

54: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
55:
56: CURSOR c_approver(rule_id IN NUMBER) IS
57: SELECT approver_seq, approver_type, object_approver_id
58: FROM ams_approvers
59: WHERE ams_approval_detail_id = rule_id
60: AND active_flag = 'Y'
61: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE -1 )
62: AND TRUNC(NVL(end_date_active,SYSDATE + 1));