APPS.PV_PARTNER_PROGRAM_PVT dependencies on AMS_APPROVERS

Line 749: (select approver_id from ams_approvers appr,ams_approval_details apdt

745: l_temp varchar2(1);
746: isavailable boolean:=false ;
747: cursor app_cur(p_prgm_type_id varchar) is
748: select 'X' from dual where exists
749: (select approver_id from ams_approvers appr,ams_approval_details apdt
750: where nvl(appr.start_date_active,sysdate)<=sysdate
751: and nvl(appr.end_date_active,sysdate)>=sysdate
752: and appr.ams_approval_detail_id =apdt.approval_detail_id
753: and apdt.approval_object_type=p_prgm_type_id

Line 782: (select approver_id from ams_approvers appr,ams_approval_details apdt

778: l_temp varchar2(1);
779: isavailable boolean:=false ;
780: cursor enr_cur(p_prgm_id varchar,edate Date) is
781: select 'X' from dual where exists
782: (select approver_id from ams_approvers appr,ams_approval_details apdt
783: where nvl(appr.end_date_active,sysdate)>=edate
784: and appr.ams_approval_detail_id =apdt.approval_detail_id
785: and apdt.approval_object_type=p_prgm_id
786: and apdt.approval_object='PRGM'